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]

As PadawanGirl stated, the special characters can be used with Char(); not directly.

So update your formula with Char(34) as below.

=Replace([Variable Name];Char(34);"")