Replace single quote in string

[kris_vliegen]

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]

Hi,

You can use :

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

[Colin-Albert · Accepted solution]

PurgeChar(YourField, chr(39))

will remove all single quotes from <YourField>

[#4]

Try this in the script...

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

[kris_vliegen]

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]

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

And I get this error in the script.

Regards,

Kris