Thanks Man-wai Field 58 is SA_JOB C(8)
Paul -----Original Message----- From: ProfoxTech <profoxtech-boun...@leafe.com> On Behalf Of Man-wai Chang Sent: 23 November 2020 14:19 To: profoxt...@leafe.com Subject: [SUSPECTED SPAM] Re: Problem with APPEND FROM <Filename> TYPE DELIMITED Sent by an external sender ------------------------------ What's the structure of your DBF, notably the definition of the 58th field? On Mon, Nov 23, 2020 at 9:14 PM Paul Newton <paul.new...@pegasus.co.uk> wrote: > > I have a CSV file (MyFile.CSV) with a single line that looks like this: > FIN005,,06/11/2020,06/11/2020,06/11/2020,T116434,C,,,,,,,N,,,,,,,8300, > ,-15,,-3,,,H,S,1,,,,,,,,,,,,,,,,,,,,,,,,,,,,LEITH > You can verify for yourselves that LEITH is the 58th column. > I have a table (MyTable.DBF) with 66 fields and Field(58) returns > SA_JOB > > The following fails to populate SA_JOB > > Select MyTable > APPEND FROM MyFile.CSV TYPE DELIMITED > > All the other columns are correct in the table. I am completely stumped so > any help would be much appreciated. -- .~. Might, Courage, Vision. SINCERITY! / v \ 64-bit Fedora 25 Server Spin /( _ )\ http://sites.google.com/site/changmw ^ ^ May the Force and farces be with you! [excessive quoting removed by server] _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/sn1pr02mb37437e98b94caf8366aa24baa1...@sn1pr02mb3743.namprd02.prod.outlook.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
