Posted by chudson007 on 03/11/06 13:21

Can somebody help me with a delimiter problem I have.

I have several PIPE (|) delimted text files which I need to import to
SQL.

With one of the files I keep encountering the following error;
"Error at Source for Row 27753. Errors encountered so far in this task:
1. Column Delimter not found."

I suspect the problem is that one record (and possibly more) has a PIPE
(|) within a field, because some of the fields contain free text.

Getting an export of the file again using a different delimter like tab
or comma will not work as these characters occur throughout the file.

I'm open to suggestions as to how to resolve this and really need to
get a solution soon.

One solution I was thinking of, but do not know how to execute is to
count the number of PIPEs on each record and then manually change the
records which have count which is inconsistent with the rest of the
file.

I've also tried importing to Access first and then SQL, as this has
worked for me in the past, but it did not work.


Regards,
Ciarán

[Back to original message]