RegEx help

[Brad1]

I've got a .txt file.

Store#Store_Name|Store_Address

I need to add a pipe after Store_Name to make this file work.  The Store Name is always the same.  The Store # - I'm not sure if the number are all the same length.  They might be.  How can I add a delimiter after a certain String is found?

#123|Kmart123_Main_St

500|Kmart200_North_St

goes to:

#123|Kmart|123_Main_St

500|Kmart|200_North_St

Thanks in advance for any help.

[atcodedog05 · Accepted solution]

Hi @Brad1 

You can use regex formula like below. Consider pipe is needed when character is followed number. Place followed by number your scenario.

REGEX_Replace([Field1], "(.*\u)(\d.*)", "$1|$2")

Hope this helps 🙂