Author Topic: Way to remove special characters from a property  (Read 1428 times)

0 Members and 1 Guest are viewing this topic.

wapperdude

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 4373
  • Ideas Visio-lized into solutions
Re: Way to remove special characters from a property
« Reply #15 on: February 11, 2022, 11:50:11 AM »
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