I am doing some simple filter formulas to pull the windows illegal characters from a text field but can’t crack the code on a few of them. I’ve tried both the “*” and the CHAR(42) in the code but no luck. Any ideas? Need this to work for the / \ | ? *
Hi Steve,
I don’t have the answer for \, but *, |, or ? work when you escape them with \. / does not need anything.
SUBSTITUTE("a?","\?","")
will return “a”
Looking for a simpler way to write complex formulas? Check out the Advanced Formula Booster at https://mdboosters.com. It’s a convenient third-party app that simplifies formula writing. With it, you can spread your formulas across several lines, utilize variables, and access dozens of functions not found in the standard formula column.