Regex Question 3

[Gamaliel]

Hello,

Can I seek help regarding this regex. Please see attached workflow.

Input:

Desired Output:

I already prepared a workflow with a regex with the account description removes "401".

Thanks.

[AkimasaKajitani]

Hi @Gamaliel 

I made the workflow using 2 RegEx tools.

1st RegEx tool only take the numeric value that is at beginning of line. This makes the Account Code Field.

The result is as follows.

Next one erases numeric value and " · " by using Replace method option.

The result is as follows.

Please check the attached workflow.

[Gamaliel]

@AkimasaKajitani  Hello, I made a revision in my regex input to show all of the formats that need to be parsed. See revised workflow.

Input:

Desired Output:

[atcodedog05]

Hi @Gamaliel 

Updated the previous workflow. If account doesn't start with number add pipe "|" before that its not parsed into column 1. Logic similar to exception case.

Hope this helps : )

[Gamaliel]

@atcodedog05 thanks. Can I ask your workflow on this?

[atcodedog05]

@Gamaliel Oops sorry i forgot 😅 have updated my above post with workflow.

[Gamaliel]

@atcodedog05  hello, by the way, i want to bring your attention to this desired output here:

 using the previous workflow, it will eliminate "401" and will just leave "k". What we want is to retain the whole word 401k. You can refer to the updated workflow I attached herewith. Thanks.

[atcodedog05]

Hi @Gamaliel 

Your workflow seems to be different please use this workflow.

[Gamaliel]

@atcodedog05  yes I tried to use this one but I noted that there is still "Total 1045 · Schwab 401k Account". It should be presented as Total Schwab 401k Account without "1045 · ". For now, I do not know of a way yet to carve this out.

Thanks.

[atcodedog05 · Accepted solution]

Hi @Gamaliel 

Got it. Try this

Hope this helps : )