Find and replace text

Hi,
I need help with a particultar situation.

I have a text field that contains the character: ’ , I need to replace it with a string.

EM_Image

How I can do this operation ?

Thanks
Leonardo

Hi Leonardo,

you can either modify this column using an expression with function replace(), e.g.

replace([ColumnA], "'", "my string")

Note that EasyMorph allows using double quotes as well as single quotes to wrap a text value. Which means that you can wrap a single quote in double quotes ("'"), or a double quote in single quotes ('"').

Alternatively, use theTable-wide replace action. With this action you can replace the character in multiple columns at once.

Thanks a lot!!
Leonardo

Is it possibile replace the linebreak() ?

Thanks
Leonardo

Yes,

replace([ColumnA], linebreak(),' ')

I tried but this command doesn't work... I used removechars([VALORE],linebreak()), but I lost the spaces between the words.

SANITIZE command solves the issue !
It replaces tabs and line breaks with spaces and removes hidden system characters with ASCII codes 0 to 31.

Leonardo

2 Likes

That’s right - “Sanitize text” is even better option.