Splitting string with Regex

[Carlyn]

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:

Date	Year	Month	Day	Amount	DR/CR	Check
20241001	2024	10	01	84,258.10	C	0000000000

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

[Towers · Accepted solution]

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]

thank you so much - it worked perfectly