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]

Description

Replaces part of a string with another string

Function Group

Character

Syntax

string Replace(string input_string; string string_to_replace; string replace_with)

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

Input

input_string                     The input string  
string_to_replace             The string within input_string to be replaced  
replace_with                    The string to replace string_to_replace with.  

Output

The string with the part replaced

Example

Replace ("New YORK";"ORK";"ork") returns "New York"

All the best,

Praveen