Way to remove special characters from a property

Started by EddieB, February 08, 2022, 09:08:27 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

wapperdude

To eliminate the double quote character, the following syntax works.  It uses the CHAR() fcn to define the equivalent quote character:
SUBSTITUTE(User.TXT,CHAR(34),"")

So, if your text looked like:  Now "IS" the time for change.  It becomes:  Now IS the time for change.
Visio 2019 Pro