Replace " from the string

[Former Member]

Hi, I am not able to remove " (double quotes) from a sting.

I am using replace function in webi but getting error.

example sting: Yellow stone"discovery"

i have tried like this: =replace([varible];""";"") but getting error. can anybody help me in removing the " from sting.

Thanks.

[Former Member · Accepted solution]

You cannot use double quotes directly in this case but double quote Ascii number like this:

=Replace ([variable]; Char(34) ;"")

[Former Member · Accepted solution]

Hey,

What about multiple characters? like

=Replace ([variable]; Char(34), Char(40), Char(44) ;"")