adding serial number after character

Question

Hello,

i have to add a serial number after a certain character to keep them separate -

Current Output

ItemABCABC

Expected Output -

ItemABC1ABC2

i am using this following formula into formula tool but its not working

if StartsWith([Item], "ABC") then REGEX_Replace([Item], "$1$2", "ABC") else [Item] endif

alexnajm · Accepted Answer

Then just add more to your Formula - IF StartsWith([Item],"ABC") THEN [Item]+ToString([RecordID]) ELSE [Item] ENDIF

Qiu · Accepted Answer

@kauser 
Follow the idea of @alexnajm we can do something like this.