topic Using Match() when comparing strings contain quotation mark in QlikView

Using Match() when comparing strings contain quotation mark

Tue, 10 Jun 2014 06:33:09 GMT

Hi:

I was trying to use Match () function to restrict loading. I was trying to compare human names in the Match() function.

But I found out that one of the names contain a quotation mark such as O'Donnell. And that would considered as an error when executing the script.

Is there a way to solve this issue?

Thank you very much.

lironbaram — Tue, 10 Jun 2014 06:42:04 GMT

only for filtering propose ,you can create another field where you'll replace the ' sign with other sign

may be *

and after you do the filter you can drop the new field

the replace function should look like

replace(FieldName,chr(39),'*') as FileldNameForFilter

Tue, 10 Jun 2014 06:46:21 GMT

Thank you Liron:

This is a good idea.

lironbaram — Tue, 10 Jun 2014 07:22:22 GMT

just a little suggestion

use other symbol than * because this is used for wild card search , may be #