Regex tool expression for column split

[Skarthika]

Hi All,

Im looking for an expression in Regex tool to extract values like below. Basically when there is an alphabet occurance there should be a split, again when there is an number there shd be a split and it goes on.

input	Data
	123, 234, 345, 2025-04-01, 456, abc, def, ghf, 23, 2025-04-02, ahf, sef, 234
output	C1	C2	C3	C4	C5
	123, 234, 345, 2025-04-01, 456	abc, def, ghf	23, 2025-04-02,	ahf, sef	234

 My data is going to be dynamic hence i cont confirm the value count or delimiter as "," in text to columns.

[flying008]

Hi, @Skarthika 

FYI.

Spoiler

\d[\d\s,-]+(?=,\s\D|$)|[a-z][a-z\s,]+(?=,\s\d|$)

[RWvanLeeuwen]

Hi there,

I built a sample workflow that helped me solve your data puzzle.

Please do let me know if this solution works for you

the recursive RegEx logic was implemented with Alteryx logic instead - hope this works :-)