Split column

Hello dear forum,

i want to create a new column with some data of an existing column. The existing column has 8numbers like:

245680046

The new column should persist of the first five numbers:

24568

How can i manage to get this column ? Greetings Thomas

Hi Thomas

I did it in a very unelegant way with Regex split node and ^(.{5}).* pattern

You have to rename column then.

Best

-agiani99

Thomas

forgot to mention youhave to temporarily use "number to string" node, split, and bring strings back to numbers.

best

-agiani99

Hi,

I just want to mention the Cell Splitter by Position node that allow splitting a column by indices.

Regards, Thomas

1 Like