Regular expression in regex tool

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

Developer

Common Use Cases

Accepted answers

Here is how I would approach 😅

Hope this helps : )

split on $%.yxmd

All comments

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

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

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

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 : )

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

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703