When trying to remove an apostrophe from this text:
[Dimensions] = "100'"
using this formula
SUBSTITUTE([Dimensions], "'", "")
I get this error: UNTERMINATED STRING
Is there a way for appsheet to not interpret the โ as a single quote? An escape character or something?
Another oddity, If I add a space after the apostrophe, then it clears the error. Very curious behavior???
SUBSTITUTE([Dimensions], "' ", "")
Solved! Go to Solution.
@Stefan_Quartemont This should do itโฆ SUBSTITUTE([DIMENSION]&, LEFT("โ โ, 1),โ")
User | Count |
---|---|
37 | |
30 | |
29 | |
22 | |
18 |