Replace nth occurrence of value in a string

[HomesickSurfer]

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;

[binu_acs · Accepted solution]

@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. 👏

[HomesickSurfer]

Thank you @binu_acs .  This works!!