>>>g'day
>>>
>>>Because I like to retain 1st row of csv file, I using the common
>>>
>>>APPEND FROM (mGetFile) TYPE DELIMITED WITH ","
>>>
>>>rather then
>>>
>>>APPEND FROM (mGetFile) TYPE CSV
>>>
>>>But with this method if data column contain common, VFP will slit the data into 2 column,
>>>
>>>eg
>>>cusno,itemNo,model,qty
>>>LD50,18340,LD90T0RELK,100
>>>LD80,18340,"LD80,T0RELK",200
>>>
>>>the 3th row of data will have 1 extra column.
>>
>>APPEND FROM (mGetFile) TYPE DELIMITED
>>
>in adddition
>
>
>APPEND FROM (mGetFile) TYPE DELIMITED FOR !nameoffirstcolum=="cusno"
>
>
>Problem was to remove first row ...
>
>update:
>
>possibly
>
>FOR !TRIM(nameoffirstcolum)=="cusno"
>
>because this is not a SQL command
If I have to process a file that has column names as the first row, I usually strip that row out with FILETOSTR/STRTOFILE. So in this case I was only concerned about the data rows.
Using TYPE CSV ignores the first row but ISTR running into problems with files that didn't always quote strings etc. There seem to be lots of different interpretations of the CSV "standard" :(
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up