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!!!

[atcodedog05]

Hi @Gamaliel 

I have modified my previous solution to fit this requirement.

Workflow:

Hope this helps : )

[atcodedog05 · Accepted solution]

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 : )

[Gamaliel]

@atcodedog05 thanks for this very terse and efficient workflow.

[atcodedog05 · Accepted solution]

Happy to help : ) @Gamaliel 

Cheers and have a nice day!

[Gamaliel]

@atcodedog05  I have additional question related to this one in Regex Question 3 - Alteryx Community.

I hope you can also help with this.

Thank you. 🙂