Skip to main content

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

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


Thanks Andrina . that works .


Reply