Hello
Anyone here know why my Alteryx formula expression isn't working?
Using the following, I intend to replace the 10th semicolon (;) in my strings with a tilde (~).
Replace([F15], "^(?:(?:[^;]*;){9}[^;]*);", "~")
Sample strings:
532.00;515;S;N;US80687P1066;20221027;20221031;2;UNT;51.49;Y; ;.15;XPAR;
533.00;515;S;N;US80687P1066;20221027;20221031;23;UNT;592.17;Y; ;1.78;XPAR;
Solved! Go to Solution.
@HomesickSurfer I think you need to use the Regex_Replace() function
REGEX_Replace([Sample strings:], '(^(?:(?:[^;]*;){9}[^;]*));', '$1~')
Thank you @binuacs . This works!!