# Regex split

**URL:** <https://forum.knime.com/t/regex-split/33285>\
**Category:** KNIME Extensions\
**Tags:** text-processing\
**Created:** [May 28, 2021, 7:33am UTC](https://forum.knime.com/t/regex-split/33285 "2021-05-28T07:33:31Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![LeaKB](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/l/d2c977/32.png) [@LeaKB](https://forum.knime.com/u/LeaKB)\
**Post date:** [May 28, 2021, 7:33am UTC](https://forum.knime.com/t/regex-split/33285/1 "2021-05-28T07:33:31Z")

</div>

Hi,  
Sorry for this probably very basic question (I am still a beginner): I have a column with street names and numbers which shall be split into 2 columns (one with street name and one with number). The problem is that sometimes there are not only numbers but also text. I am using Regex split (\D.+)\s(\d(?:.+)?) but it doesn’t work for all cells (if there is not only a number but also words).

Some examples that don’t work:  
Altmannsdorfer Anger 27/Weg 4/87 (should be Altmannsdorfer Anger AND 27/Weg 4/87)  
Adolfstorgasse 15-17/Haus 20/B/2 (should be Adolfstorgasse AND 15-17/Haus 20/B/2)  
Neubergenstraße 30b/25+ 26 (should be Neubergenstraße AND 30b/25+ 26)  
Mariahilfer Straße 137/Königsklostergasse 100/20 (should be Mariahilfer Straße AND 137/Königsklostergasse 100/20)  
Margeritenweg 20/Parz. 33 (should be Margeritenweg AND 20/Parz. 33)

Can anyone help with this? I would be eternally grateful.

Many thanks,  
Lea

---

<div class="post-metadata">

**Author:** ![rd2575691](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/r/c5a1d2/32.png) [@rd2575691](https://forum.knime.com/u/rd2575691)\
**Post date:** [May 28, 2021, 7:53am UTC](https://forum.knime.com/t/regex-split/33285/2 "2021-05-28T07:53:54Z")

</div>

[regex\_street.knwf](https://forum.knime.com/uploads/short-url/g3X2LHXKz9Hg5pGJjSyveKqf3hI.knwf) (23.3 KB)  
Does this help?

---

<div class="post-metadata">

**Author:** ![LeaKB](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/l/d2c977/32.png) [@LeaKB](https://forum.knime.com/u/LeaKB)\
**Post date:** [May 28, 2021, 11:43am UTC](https://forum.knime.com/t/regex-split/33285/3 "2021-05-28T11:43:11Z")

</div>

This is great!! Many thanks!!

But now I have the problem that I can only rename column “Full Match” but not column “Group 1” (the one I need actually), do you know why? It’s not in the list to choose from.

Also, I get the message ‘Node created an empty data table’.

I have an Excel Writer between the joiner and the column rename and both columns are in there.

Many thanks,  
Lea

---

<div class="post-metadata">

**Author:** ![LeaKB](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/l/d2c977/32.png) [@LeaKB](https://forum.knime.com/u/LeaKB)\
**Post date:** [May 28, 2021, 12:10pm UTC](https://forum.knime.com/t/regex-split/33285/4 "2021-05-28T12:10:11Z")

</div>

Hi,

I have fixed this now, however, the Joiner has re-organised the data (I have over 60 columns) I think cause none of the nodes after the joiner work anymore. After the joiner I compare columns and before I had around 29k matches, now apparently 5 (not k!!)…

Maybe you have an idea, what happened?

Thanks,  
Lea

---

<div class="post-metadata">

**Author:** ![system](https://forum-cdn.knime.com/uploads/default/original/1X/ab3ccf34482a0329361734a18199390177204f15.png) [@system](https://forum.knime.com/u/system)\
**Post date:** [June 2, 2023, 9:40pm UTC](https://forum.knime.com/t/regex-split/33285/5 "2023-06-02T21:40:26Z")

</div>

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