Regex split

I am trying to split a column like this:
parent_folder_arr8
01.01 Baba Dochia
01.01 Baba Dochia
01.01 Baba Dochia
01.01 Baba Dochia
01.01 Baba Dochia
Into to separate columns
split_1 split_2
01.01 Baba Dochia
01.01 Baba Dochia
01.01 Baba Dochia
01.01 Baba Dochia
01.01 Baba Dochia

I use following regex : {5}([0-9])[ -](.*$)
The result is:
split_1 split_2
01 .01 Baba Dochia
01 .01 Baba Dochia
01 .01 Baba Dochia
01 .01 Baba Dochia
01 .01 Baba Dochia

Any suggestions will be appreaciated
Thank you in advance !

Hi @cristina_ursta

Why not use the Cell Splitter by Postion node, and configure it like this.
Schermafdruk van 2021-09-19 09-12-38
gr. Hans

3 Likes

(.{5})\s(.*)

should give you your regex results
but @HansS Solution should work so regex is not required.
br

4 Likes

thank you for the tip @HansS !!

2 Likes

Thank you @Daniel , yes @Hans solution works, but it is great to have the Regex option too!

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.