>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.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)