How to remove special char ' in my string ?

[varunvarma]

Hello All,

How to remove special char ' in my string.

EG :- I have data like this

INDI'A

CHI'NA

SINGAP'ORE

Here i want to remove symbol ' and my output should be like this

INDIA

CHINA
SINGAPORE

I am using REPLACE function and it is working for symbols like .,-  but not working for '   Please let me know how to do this.

Thanks in advance.

[#2]

try this

replace(fieldname,''','')

i modified this by

=replace(fieldname, chr(39) ,'')

this working fine

[tresesco]

PurgeChar(YourField, '.-`@#$%^&')

and if ther is single quotes try like:

PurgeChar(YourField, '.-`@#$%^&' &chr(39))

[#4]

You can use keepchar('Fieldname','A-Z') May be it vl work

[MarcoWedel · Accepted solution]

purgechar(string, chr(39))

[#6]

hi

=PurgeChar(fieldname,chr(39))

[jagan]

Hi Varun,

Use KeepChar() like below

LOAD

*,

KeepChar(FieldName, 'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ') AS FormattedColumn

FROM DataSource;

Hope this helps you.

Regards,

jagan.

[#8]

Hi

Try Replace() to get string only from the field.

Regards

Charitha

[varunvarma]

Thank you all. I got it.

[jagan]

Hi Varun,

Please close this thread by giving/clicking Correct and Helpful answers to the useful posts, it helps others in finding the answers.

Regards,

Jagan.