SQLTeam.com | Weblogs | Forums

Replacing character in several columns?

Hello,

I have to export data from a table to a text file where the delimiter is a pipe (|). I have configured SSMS to do this. This data is then imported into a reporting tool but the import is falling over because several columns have a pipe in them (mainly descriptions).

Is there a way I can "clean" the data in my table to strip out any pipes and replace them with, say, a space?

Many thanks.

one idea is before exporting replace in the columns

"Rasta"|"pickles"|"rona"|"dinho"

Put the data in quotes