Separation of one column into two columns

[alex1368]

Do not be bored with greetings
I have an excel table containing a lot of phone numbers
I want to separate the contents of this column from the right side by 2 characters and separate them into 2 independent columns through knime
I have prepared a sample file and I hope you can help me
sammmm.xlsx (10.1 KB)

[hmfa]

Hi @alex1368
Use node

Cell Splitter By Position

Br

[alex1368]

Hello
Thanks for your reply, but there is a problem!!
In this node, it separates based on commas, while I want it to separate the first 2 characters from the left side and display the first 2 characters in one column and the rest in another column.

[hmfa]

Hi @alex1368 .
Is this what you need?

Try it
cell splitter by position.knwf (72.9 KB)
Br

[alex1368]

Thank you for your reply
In the second field, I only entered the name of one column, that’s why I got an error and it was not possible to execute
Once again, I thank you for your answer and for fixing the problem that you did