topic Re: Remove ' from text in App Development

Remove ' from text

Neha121 — Thu, 20 Mar 2025 02:44:26 GMT

Hi,

My text is SOLICITOR'S OFFICE in one of the dimension. I want to remove ' before S. how do I do that in script. how do I use replace().

Thanks.

Re: Remove ' from text

Digvijay_Singh — Thu, 20 Mar 2025 03:26:14 GMT

Something like this or a little different based on what fits for you may be -

Replace(text,'''S','S')

Re: Remove ' from text

Neha121 — Thu, 20 Mar 2025 03:34:23 GMT

tried this but doesn't work

Re: Remove ' from text

Digvijay_Singh — Thu, 20 Mar 2025 04:21:50 GMT

Works for me, see if you did something different than I did as below -

data:

Load *,

Replace(text,'''S','S') as text_modified

;

Load * inline [

text

SOLICITOR'S OFFICE

];

Re: Remove ' from text

Chanty4u — Thu, 20 Mar 2025 05:06:01 GMT

Try this

LOAD

Replace([YourField], '''', '') AS CleanedField

FROM [YourSource];

LOAD

PurgeChar([YourField], ' ' ' ') AS CleanedField

FROM [Your source];

Re: Remove ' from text

simsa — Thu, 20 Mar 2025 06:57:42 GMT

Any of the below method will do:

Re: Remove ' from text

Lech_Miszkiewicz — Thu, 20 Mar 2025 07:01:46 GMT

Hi,

Maybe you are having different character than ' ?

Answers above are correct so you may want to just make sure you are replacing correct character as it can be different than '.

It may be ' or ` or something else

cheers

Re: Remove ' from text

Chanty4u — Thu, 20 Mar 2025 13:10:31 GMT

Or you can use A to Z all upper case and a to z lower case in ' ' below expression

LOAD

KeepChar(field, 'A-Z a-z ') AS CleaText

FROM source

So that you can remove any symbols ...it will keep only characters

Re: Remove ' from text

JandreKillianRIC — Thu, 20 Mar 2025 13:14:22 GMT

Hi @Neha121

If the above solutions dont work using KeepChar()

Example

KeepChar(Field, 'qwertyuiopasdfghjklzxcvbnmQWERTYUIOPASDFGHJKLZXCVBNM 0123456789') as TestFieldWithoutChar

Regards Jandre