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


Community Terms of Use & ConditionsCookie settings