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.
Here is how you cna do it using a referential for exceptions !
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 : )
Hi @Gamaliel ,
What is the logic behind ?
Why is 1000a account code and 401k account name ? is there a pattern ?
@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
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.
Do you have a list of exceptions similar to 401k?
@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.
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.
