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.
Hi @Gamaliel
Got it. Try this
Hope this helps : )
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.
Please check the attached workflow.
@AkimasaKajitani Hello, I made a revision in my regex input to show all of the formats that need to be parsed. See revised workflow.
@Gamaliel Oops sorry i forgot 😅 have updated my above post with workflow.
Your workflow seems to be different please use this workflow.
@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.
Happy to help : ) @Gamaliel Cheers and have a nice day!
