Parsing out special characters in outfile

clem_c_rock · Joined: 18 Aug 2004 Posts: 19

Hello,
I am looking for a way to parse out certain characters when I write a select statement to an outfile.

I know how to escape the characters w/ the escaped by clause, but I need to parse off some double quotes and some backslashes.

I'm currently trying this:

clem_c_rock · Joined: 18 Aug 2004 Posts: 19

Found the solution I was looking for (nested REPLACE statements):

insert into artists(name) values(REPLACE(REPLACE(REPLACE(name,'!', ''),'"', ''),'\302\256', '') );