Thanks Sergey.

I just did it by replacing the , with a \r in the Find-Replace dialog while modi file.


>>I have file (test.txt), with about 1,000 fields separated by a comma. Anyone know how I can append this into a one field table, or perhaps convert the comma (,) into an enter return so I can append this into a table?
>>
>>Note: each line has more than one field, so that is why I just can't do a quick append from type csv, etc. However, each item is separated by the comma.
>
>

>lcFileIn = "test.txt"
>lcFileOut = "Test2.txt"
>lcCrLf = CHR(13) + CHR(10)
>
>STRTOFILE( CHRTRAN(FILETOSTR(lcFileIn), [,], lcCrLf), lcFileOut)
>...
>