How to split a string into different cells

Hello i am a student that just started to use KNIME, so I’m really new to this. How do i split a cell string into different columns / rows ?

What im aiming is Petrol | Engines | Year | Horsepower | Engine displacement | Compare with another car

Could you upload the data?

You mean the .knwf file ?

Yes if you have a workflow already. Make sure it includes the data. Otherwise just post the data.

ND1.knwf (84.9 KB)

Hello @Zaza and welcome to the KNIME community:

You can test ‘Regex Split’ node with the following code:

([A-Z].+)([A-Z].+)([A-Z].+)([A-Z].+)([A-Z].+)([A-Z].+)

BR

2 Likes

It worked, thanks a ton, have a nice day/evening.

1 Like

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