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