Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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

1 Solution

Accepted Solutions
lironbaram
Partner - Master III
Partner - Master III

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

View solution in original post

3 Replies
lironbaram
Partner - Master III
Partner - Master III

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
Author

Thank you Liron:

This is a good idea.

PC

lironbaram
Partner - Master III
Partner - Master III

just a little suggestion

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