Dear KNIMErs, I have a table that looks like this: [image] I want to achieve, that the names in column A are “split up” in different rows. Cell A2 should read: Smith, John Cell A3 should read: Miller, Peter Cell A5 should read: Doe, Frank Cell A6 should read: Davies, Rhonda Like this: [image] Some things to note here: the differentiation between name pairs seems is a comma (",") the differentiation between first name and last name is a comma and a space (", ") I already was able to create additional row copies by counting the number of occurrences of the sequence (", ") → comma and space and by using the One to Many Rows Node Any idea is highly welcome, thanks a lot in advance :slight_smile: Here’s the Excel list: list-of-names.xlsx (10.6 KB)

Hi @kowisoft , and here a workflow with a different approach using the unpivoting node :slight_smile: [image] Split Cells and Create New Rows – kathrin Solutions for data science: find workflows, nodes and components, and collaborate in spaces. Cheers Kathrin

Split by regex

KNIME Analytics Platform

ipazin December 9, 2021, 11:15am 8

Hello @kowisoft,

take a look here:

And for testing regex I use this page:

Br,
Ivan

2 Likes