>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)
...
--sb--