Regular expression in regex tool

[SH_94]

Dear community, 

i am trying to understand the regex expression in one of the workflow and the expression as follow:

(.*?)(?:\$%|$)

Does anyone know how to interpret this expression ?

In addition, may i know when we would need to use tokenise and when we can use parse ?

Many thanks again for the help

[atcodedog05]

Hi @SH_94 

Can you provide some sample data so that we know what it's doing? There are multiple ways to Regex for a single thing.

[binuacs]

@SH_94  you can find more about RegexTokenize in the below link

https://inspiringingenuity.net/2014/06/11/alteryx-regular-expression-tokenize/

[atcodedog05]

Hi @SH_94 

Another way to know more about a specific Regex is through using https://regexr.com/

Enter the expression above and it will give you the explanation below

Hope this helps : )

[SH_94]

Hi @atcodedog05 ,

Below is my one of the sample data

IXHD$%CCC_ID$%SSS_ID$%SBBB_CARD_NO$%SS_STATUS_CODE$%CC_CODE$%UFUF_TYPE$%CUST_SUB_TTPE$%RC_CHARGE_S23EQ_NO$%XXX_CODE$%EEE_DATE$%EXXX23_eDATE$%RC_CHARGE_AMT$%SERRR_RERR_TYPE$%SERVICE_RECCC_ID$%PAY_C…

Basically i want to split $% as delimited and want to understand why the above complex expression is needed to split the column with the delimited $%

Thank again

[atcodedog05]

Hi @SH_94 

(.*?) means character before character before $%

(?:\$%|$) is searching for $ or $% 

its on tokenize which means it captures characters followed by $ or $% into each line there by spliting

Hope this helps : )

[atcodedog05 · Accepted solution]

Hi @SH_94 

Here is how I would approach 😅

Hope this helps : )

[atcodedog05]

Happy to help : ) @SH_94 

Cheers and have a nice day!