topic Re: Replace single quote in string in QlikView

Replace single quote in string

kris_vliegen — Thu, 13 Mar 2014 12:55:00 GMT

Hello All,

I have customer-names with a single quote in it.

How can I replace this single quote into a blank in the reload-script?

Regards

Kris

christophebrault — Thu, 13 Mar 2014 12:58:26 GMT

Hi,

You can use :

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

Colin-Albert — Thu, 13 Mar 2014 13:00:44 GMT

PurgeChar(YourField, chr(39))

will remove all single quotes from <YourField>

Thu, 13 Mar 2014 13:01:38 GMT

Try this in the script...

PurgeChar(Cust_Name, chr(39)) as Cust_Name;

kris_vliegen — Thu, 13 Mar 2014 13:12:01 GMT

Thanks for the quick response.

The PurgeChar is working for me.

I'm reading from an i-series database.

And I try to implement google maps.

I get an error if I try to read this Field.

How Can I convert this 'blok' caracter to a space?

Regards,

Kris

kris_vliegen — Thu, 13 Mar 2014 13:17:53 GMT

And I see this field in Qlikview as just a normal text

And I get this error in the script.

Regards,

Kris