Skip to Content
avatar image
Former Member

Replace " from the string

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • Best Answer
    avatar image
    Former Member
    Mar 14, 2011 at 09:29 PM

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

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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hey,

      What about multiple characters? like

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

  • avatar image
    Former Member
    Mar 15, 2011 at 07:06 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 15, 2011 at 07:58 AM

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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 15, 2011 at 06:53 AM

    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?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 15, 2011 at 07:05 AM

    i

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 15, 2011 at 01:27 PM

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

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

    Thanks Everybody for the reples.

    Add comment
    10|10000 characters needed characters exceeded