>>>>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" :(
We don't like to made the things complicated to the OP, don't we?
I just read the whole thing plain and process through SQL.
CSV is a good example of
standard ;)
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord
Weeks of programming can save you hours of planning.
OffThere is no place like [::1]