Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
purgechar(string, chr(39))
try this
replace(fieldname,''','')
i modified this by
=replace(fieldname, chr(39) ,'')
this working fine
PurgeChar(YourField, '.-`@#$%^&')
and if ther is single quotes try like:
PurgeChar(YourField, '.-`@#$%^&' &chr(39))
You can use keepchar('Fieldname','A-Z') May be it vl work
purgechar(string, chr(39))
hi
=PurgeChar(fieldname,chr(39))
Hi Varun,
Use KeepChar() like below
LOAD
*,
KeepChar(FieldName, 'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ') AS FormattedColumn
FROM DataSource;
Hope this helps you.
Regards,
jagan.
Hi
Try Replace() to get string only from the field.
Regards
Charitha
Thank you all. I got it.
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.