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
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
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
