Forum Discussion

MichaelTamoush's avatar
MichaelTamoush
Qrew Captain
6 years ago

Text fields behavior with quotes and other symbols

I have a text field and I can't quite figure out when this happens, but sometimes it changes a quote (") symbol to &#65533. And sometimes if I have a lookup field, it changes it to a little square. ...
Tables and fields
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
6 years ago
right, you I realize that you would never be able to train the users, but if they hold down the " they get all the different flavors of quotes.  

We can probably make a formula or an Automaton to substitute the correct quotes for the bad quotes.  maybe contact me off line.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
MikeGerrity1's avatar
MikeGerrity1
Qrew Member
2 years ago

Does anyone have a formula for stripping out "curly quotes" from text.  

A basic searchandreplace does not work because quickbase can't search for curly quotes - but perhaps there is a way to search for the ASCI Character.

This has become an issue for me within Pipelines which fail when transfering text that includes curly quotes or other disallowed characters.  I have tried using the jinja "escape" feature ie {{a.content_clean|escape}} but that has not made a difference...

Thanks for any suggestions



------------------------------
Mike Gerrity
------------------------------