Split Text

[ARock1980]

Hello everyone, I have the following problem:

In a table are names of restaurants. I want to separate these names as follows (see Table Input → Name / Output → Location 1 & 2)

Seperate Names.xlsx (8.9 KB)

I am sure there is a quick and simple solution for this

Thanks

[aworker]

Ciao Andreas @ARock1980

Please find a possible solution here below:

20210618 Split Text.knwf (36.7 KB)

Hope this helps

Auguri,

Ael

[ARock1980]

Thanks alot @aworker … It works great

[ipazin]

Hello @ARock1980,

if you know regex then you can use Regex Split node as a one node solution. Here is expression that worked on data you provided but might need modification in order to work on entire data set you have:

([a-zA-Z]+)_+([a-zA-Z]+)

Br,
Ivan

[aworker]

Thanks @ARock1980 for your kind words and for validating the answer !