String function - "|" not working in string functions.
I need to replace "|'" with spaces on a strung. I am not able to use any string functions with '|'. '|' always defaults to '\'.
Solved! Go to Solution.
Are you using RegEx to do this?
It works for me if I just do a simple Replace([Field1], '|', ' ')
If you are using RegEx it will not work because '|' means something to RegEx; it's a special character which means 'or'. So if you are entering REGEX_Replace([Field1], '|', ' ') you are giving it a nonsensical instruction. To make RegEx recognize '|' as a non-special character you must use the escape character ('\') in front of it; REGEX_Replace([Field1], '\|', ' ')
I hope this makes sense and works for you 🙂
I want to respond to this comment
I think that when you look at the formula it only appears to have a forward slash(?) because of the italicizing that Alteryx does. If you look at @G1's example, you can see that his notations under the tool show the pipe (|), but it looks like /