Skip to main content
Answer

remove single quotation mark

  • April 7, 2025
  • 2 replies
  • 36 views
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

    2 replies

    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

    A
    M
    Data Voyager

    Thanks Andrina . that works .

    A
    Community Terms of Use & ConditionsCookie settingsAccessibility statement