RE: Problem with APPEND FROM <Filename> TYPE DELIMITED

Thanks Tracy

I know that SA_JOB is the 58th field in the table FIELD(58) returns SA_JOB

Paul

-----Original Message----- From: ProfoxTech profoxtech-bounces@leafe.com On Behalf Of Tracy Pearson Sent: 23 November 2020 14:19 To: profoxtech@leafe.com Subject: RE: Problem with APPEND FROM <Filename> TYPE DELIMITED

Sent by an external sender ------------------------------

Hi Paul,

cmd = "CREATE CURSOR mytable (" FOR ii = 1 TO 66 cmd = cmd + "F" + TRANSFORM(ii) + " c(10)" IF ii < 66 cmd = cmd + "," ENDIF NEXT cmd = cmd + ")" &cmd. Select MyTable APPEND FROM MyFile.CSV TYPE DELIMITED BROWSE LAST NOWAIT

F58 gets the value LEITH

I don't have a reason why your 58th field is being populated. List Structure of MyTable will give you the field number next to the field name. This may help you verify your table.

HTH, Tracy

-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Paul Newton Sent: Monday, November 23, 2020 8:15 AM To: profoxtech@leafe.com Subject: Problem with APPEND FROM <Filename> TYPE DELIMITED

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]