DSXchange

Hi All,

I have a requirement to trim i.e, remove single quote ' and double quote " from a string.

How can I do this.
I tried the following

Trim (string,'"','A') and also Trim(string,''','A')

But this does not work.

Any help.

Thanks
Devi

Try with an escape character. Like Trim(Input.Col,"\'",'A'). Or use the ascii value for the characters. Trim(Input.Col,CHAR(39),'A')

In Server would work but I don't know if that applies to PX transforms. If not, use

Does backslash work as a quote character? If so you can have