Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
PurgeChar(YourField, chr(39))
will remove all single quotes from <YourField>
Hi,
You can use :
=replace(YourFieldName,chr(39),' ')
PurgeChar(YourField, chr(39))
will remove all single quotes from <YourField>
Try this in the script...
PurgeChar(Cust_Name, chr(39)) as Cust_Name;
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
And I see this field in Qlikview as just a normal text
And I get this error in the script.
Regards,
Kris