Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Replacing particular occurrence of a character

ACE Emeritus
ACE Emeritus

That's exactly what I need!

ACE Emeritus
ACE Emeritus

Glad we finally found a RegEx for it!  I also did a workflow that allows variable Find String, Replacement String, and Occurance number; (attached).



I think I like the RegEx more. LOL. 


Ha! I couldn't figure out the double parentheses part. Nice solution, jdunkerley!


To put that Inspire training into practice, I created a macro tool for you. You can specify the character you want to change, the character to replace it with, and the occurance location.