Hi all The problem was that one of the preceding fields was a memo field, so CSV column 58 was ending up in table field 59 (which happened to be a logical field so could not accept "LEITH".
Many thanks everybody Paul Newton -----Original Message----- From: ProfoxTech <profoxtech-boun...@leafe.com> On Behalf Of Ajit Abraham Sent: 23 November 2020 14:43 To: profoxt...@leafe.com Subject: Re: Problem with APPEND FROM <Filename> TYPE DELIMITED Sent by an external sender ------------------------------ Sure Paul. On 23/11/2020 17:27, Paul Newton wrote: > Thanks Ajit > > Can I send you my table and CSV? > > Paul > > -----Original Message----- > From: ProfoxTech <profoxtech-boun...@leafe.com> On Behalf Of Ajit > Abraham > Sent: 23 November 2020 14:14 > To: profoxt...@leafe.com > Subject: Re: Problem with APPEND FROM <Filename> TYPE DELIMITED > > Sent by an external sender > ------------------------------ > > Hi Paul, > I created a 60 col table (all character type) and append that line. The 58th > col correctly has the word 'LEITH' > So for me, it is behaving as expected. > I have uploaded both the files to https://we.tl/t-txhbr0rAAM Ajit > > > On 23/11/2020 16:14, Paul Newton wrote: >> Hi all >> >> 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. >> >> Paul Newton >> [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/sn1pr02mb3743f438a403312c3cfcb130a1...@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.
