Regex Tool

[Gamaliel]

Hello,

I would appreciate your help in using the correct regex code for this one.

Input:

Output

Thank you so much. Please see attached workflow.

[Jean-Balteryx]

Hi @Gamaliel ,

What is the logic behind ?

[atcodedog05]

Hi @Gamaliel 

Why is 1000a account code and 401k account name ? is there a pattern ?

[Gamaliel]

@Jean-Balteryx @atcodedog05  we would like to separate the codes from the account names except for 401K since it is not an account code per se. The goal again is to provide a regex code that will separate the account codes from the account names with the exception of 401K since it is not a code but an account description/name

[Gamaliel]

401k is not a code. Basically , we would like to provide exceptions for the strings which are numeric but should not be treated as account codes. E.g. 401k, it is not a code but it is an account description for retirement funds.

[atcodedog05]

Hi @Gamaliel 

Do you have a list of exceptions similar to 401k?

[Gamaliel]

@atcodedog05 currently we dont have such scenario yet. We are now building a workflow which is flexible to every set of general ledgers so that whenever we encounter this issue, our workflow will easily address them.

[Jean-Balteryx · Accepted solution]

Here is how you cna do it using a referential for exceptions !

[Gamaliel]

Thanks on this @Jean-Balteryx . this is helpful. Though we need to list out the exceptions manually first, still this is helpful since this is just limited to rare circumstances. 

[atcodedog05 · Accepted solution]

Hi @Gamaliel 

My take on this. I am modifiying the expection so that it doesnt get added in account code.True, exception list will be required.

Workflow:

Hope this helps : )