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.