Remove ' from text

[Neha121]

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.

[Digvijay_Singh]

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

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

[Neha121]

tried this but doesn't work

[Digvijay_Singh · Accepted solution]

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

];

[Chanty4u]

Try this 

LOAD  

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

FROM [YourSource];

Or 

LOAD  

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

FROM [Your source];

[simsa]

Any of the below method will do:

[Lech_Miszkiewicz]

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

[Chanty4u]

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

[JandreKillianRIC]

Hi @Neha121 

If the above solutions dont work using KeepChar() 

Example

KeepChar(Field, 'qwertyuiopasdfghjklzxcvbnmQWERTYUIOPASDFGHJKLZXCVBNM 0123456789') as TestFieldWithoutChar

Regards Jandre