Skip to main content
Solved

remove single quotation mark

M
Data Voyager

Hello everyone,

How can I  remove multiple characters, including the single quotation mark, for each row in the INPUT column  with a string data type in OneWeb (advance expression)  , e.g :- 

 

 

INPUT

 
 

RETURN VALUE

 
 

'Tom Smith' 'Laura Jones'

 
 

Tom Smith Laura Jones

 
 

Tom's

 
 

Toms

 
 

NULL

 
 

NULL

 

Thanks in advance.

Sabyasachi

Best answer by Adrian Anderson

Hi Sabyasachi.

There are a few ways to do this in advanced expressions.

Probably the easiest is to use the replace() function, e.g.:

replace( in_str, "'", "" )

Change ‘in_str’ to whatever the input field is called.

Let us know if this helps.

Kind regards,
Adrian

View original
    Did this topic help you find an answer to your question?

    A
    Ataccamer
    Forum|alt.badge.img+1

    Hi Sabyasachi.

    There are a few ways to do this in advanced expressions.

    Probably the easiest is to use the replace() function, e.g.:

    replace( in_str, "'", "" )

    Change ‘in_str’ to whatever the input field is called.

    Let us know if this helps.

    Kind regards,
    Adrian

    M
    Data Voyager

    Thanks Andrina . that works .

    Reply


    Community Terms of Use & ConditionsCookie settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie settings