In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Splitting string with Regex

Carlyn
8 - Asteroid

Hi

I have very limited knowledge of using Regex and I am trying to work out the most efficient way to split the below string.

202410012024100100000000000084258.10C0000000000

 

into the following columns:

DateYearMonthDayAmountDR/CRCheck
2024100120241001   84,258.10C0000000000

 

Is Regex the best tool for this? Can someone help with how best to do it please?

2 REPLIES 2
Towers
11 - Bolide

Hi @Carlyn,

I've created a regex pattern that can split the data into the desired columns based on the example you provided.

Ive attached a workflow with the solution, please let me know if this works for you ðŸ˜„

Carlyn
8 - Asteroid

thank you so much - it worked perfectly

Labels
Top Solution Authors