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-boun...@leafe.com] On Behalf Of Paul
Newton
Sent: Monday, November 23, 2020 8:15 AM
To: profoxt...@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]
_______________________________________________
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/000001d6c1a3$977a6820$c66f3860$@powerchurch.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.
