Use cust #define crlf Chr(13)+Chr(10) lcFile='custdata.txt' Delete File (lcFile) Scan StrToFile(Left(id,+)+left(name,25)+crlf,lcFile,1) EndScan>I have a table:
>SELECT LEFT(cust_id,6),LEFT(name,25) FROM cust TO FILE CUSTDATA >>
>USE cust >LIST FIELDS LEFT(cust_id,6)+LEFT(name,25) TO FILE CUSTDATA OFF NOCONSOLE >>
> XXXXXXYYYYYYYYYYYYYYYYYY > XXXXXXYYYYYYYYYYYYYYYYYY >>
>XXXXXXYYYYYYYYYYYYYYYYYY >XXXXXXYYYYYYYYYYYYYYYYYY >>Please advise.