topic Re: How to remove special char ' in my string ? in QlikView

How to remove special char ' in my string ?

varunvarma — Thu, 18 Sep 2014 07:38:58 GMT

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.

Re: How to remove special char ' in my string ?

Thu, 18 Sep 2014 07:40:58 GMT

try this

replace(fieldname,''','')

i modified this by

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

this working fine

Re: How to remove special char ' in my string ?

tresB — Thu, 18 Sep 2014 07:41:35 GMT

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

and if ther is single quotes try like:

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

Re: How to remove special char ' in my string ?

Thu, 18 Sep 2014 07:42:08 GMT

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

Re: How to remove special char ' in my string ?

MarcoWedel — Thu, 18 Sep 2014 07:42:29 GMT

purgechar(string, chr(39))

Re: How to remove special char ' in my string ?

Thu, 18 Sep 2014 07:48:10 GMT

=PurgeChar(fieldname,chr(39))

Re: How to remove special char ' in my string ?

jagan — Thu, 18 Sep 2014 08:07:26 GMT

Hi Varun,

Use KeepChar() like below

LOAD

KeepChar(FieldName, 'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ') AS FormattedColumn

FROM DataSource;

Hope this helps you.

Regards,

jagan.

Re: How to remove special char ' in my string ?

Thu, 18 Sep 2014 08:09:15 GMT

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

Regards

Charitha

Re: How to remove special char ' in my string ?

varunvarma — Thu, 18 Sep 2014 09:20:54 GMT

Thank you all. I got it.

Re: How to remove special char ' in my string ?

jagan — Thu, 18 Sep 2014 09:24:49 GMT

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.

Re: How to remove special char ' in my string ?

varaprasad0816 — Thu, 27 Feb 2020 18:24:09 GMT

Correct