Replace nth occurrence of value in a string

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;

Regex

Accepted answers

binu_acs

@HomesickSurfer I think you need to use the Regex_Replace() function

REGEX_Replace([Sample strings:], '(^(?:(?:[^;]*;){9}[^;]*));', '$1~')

All comments

binu_acs

@HomesickSurfer I think you need to use the Regex_Replace() function

REGEX_Replace([Sample strings:], '(^(?:(?:[^;]*;){9}[^;]*));', '$1~')

BS_THE_ANALYST

Thank you @binu_acs for your logic. I learned alot from your solution. 👏

RepeatedLookingForwardGroups.yxmd

HomesickSurfer

Thank you @binu_acs . This works!!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15881

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703