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-bounces@leafe.com On Behalf Of Ajit Abraham Sent: 23 November 2020 14:43 To: profoxtech@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-bounces@leafe.com On Behalf Of Ajit Abraham Sent: 23 November 2020 14:14 To: profoxtech@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]