I am trying to import a text file via DTS that has an unusual delimiter. I
am used to files like this

A,B,C
D,E,F

This file is like this

A,B,C There is a square here D,E,F

How do I handle a file like this that has more than one record per line and
has a square at the beginning of each record? Any help is appreciated.

Thanks

it's probably not a square, but a terminator of some sort like a hard line
feed or carriage return. Could be anything really. Most fonts won't
represent system characters like that in a text editor.
A simple way to fix it, would be to use something like Metapad to replace
those "squares" with a new line feed to make your rows show up properly.

--
Simon Worth


"Andy" <Andy (AT) discussions (DOT) microsoft.com> wrote

Andy,

Look at your file in a hex editor.

Ilya

"Andy" <Andy (AT) discussions (DOT) microsoft.com> wrote

Do you have any other suggestions? My file is over 3 million records, so it
chews up a lot of memory just to open the file. Thanks