Using Match() when comparing strings contain quotation mark

[#1]

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

[lironbaram · Accepted solution]

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]

Thank you Liron:

This is a good idea.

PC

[lironbaram]

just a little suggestion

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