Regex Part 2 Question

Gamaliel

Hello,

I am asking again another question related to my first query in this link: Solved: Re: Regex Tool - Alteryx Community. It is just that there are additional account name formats that have to be considered in making accurate regex codes:

Input:

Desired Output:

Please see attached workflow. Dont worry about the 401K pensions account since it was already resolved in the first question.

Massive thanks!!!

regex for concat.yxmd

atcodedog05

Hi @Gamaliel 

Please find the revised workflow sorry i just realized i forgot a small thing. Number should be 1050 but it was showing 1050- in the output. I fixed it by triming it

Hope this helps : )

regex (1).yxmd