>>Unfortunately the way these files are designed there are both carriage returns and linefeeds embedded in the row.
>>
>>It is an SDF file of variable length but always has a carriage return followed by a line feed at the end of each line.
>>
>>Is there a way to deal with this?
>
>CR+LF is the standard end-of-line symbol in the DOS/Windows world.
>
>APPEND FROM, or IMPORT, should deal with this correctly.
Create table testimport ( testfield Chr(10) )
StrToFile( 'a' + Chr(13) + Chr(10) + 'b' + Chr(13) + 'c' + Chr(13) + 'd' + ;
Chr(10 ), "test.txt" )
Append From test.txt type sdf
I'm getting 4 records.