I would like to use search item, if item matches then display result. But when i type text with single quote there is issue ;(((
1 Like
This must be your favourite error message 
You may need to do a text replacement routine on your search term to change the apostrophe to another character while you work with a csv table. I remember doing something similar in the google apps script so that the data that came down had apostrophe replacements, then once the data was converted to an AI2 list i reversed the replacement.
The alternative is to not use apostrophes in your data. You can setup routines in the app or in google sheets to prevent their use or to remove them if present.
1 Like
Unicode has another character for apostrophe, which may not be recognised as such by the CSV:
U+02BC
See Spacing modifier letters:
and the html entity is '
1 Like
This must be your favourite error message 
1 Like
You may get unexpected results using double quotes to provide query criteria....
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.