>>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
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]