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) ;"")

[Former Member]

I am able to solve this issue yesterday with the below code.

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

Thanks Everybody for the reples.

[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);"")

[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

[Former Member]

i

[Former Member]

Hai,

Have you tried like this

=Replace(column name; "string_to_replace"; "string replace_with")

if so it woks fine

Can you please post the error you are getting?