Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Using Match() when comparing strings contain quotation mark

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.

PC

Tags (1)
1 Solution

Accepted Solutions
lironbaram
Not applicable

Re: Using Match() when comparing strings contain quotation mark

hi

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

3 Replies
lironbaram
Not applicable

Re: Using Match() when comparing strings contain quotation mark

hi

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

Not applicable

Re: Using Match() when comparing strings contain quotation mark

Thank you Liron:

This is a good idea.

PC

lironbaram
Not applicable

Re: Using Match() when comparing strings contain quotation mark

just a little suggestion

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