We have a csv file that we get and we would like to programatically read it into a sql database. The problem is it is delimited by a Pipe rather than a carriage return, comma, or semicolon. Can anyone show me a way to look for the pipe and replace it with a carriage return or comma? Thanks for the help and examples are appreciated.

I would suggest using sql server DTS to import your data.

That would be great, but not an option at this point. Any other suggestions?