extrapolate characters from excel cell

Good morning
I would need to extrapolate from an Excel cell the characters before the “-” and copy them to a new cell, and then copy the characters after “-” and then copy them to another cell.
Which node should I use ?

example:
A1: 1234-67
output
A2: 1234
A3:67

Best regards
Luigi

Hi @lriva

This can easily be done using a -Cell Splitter- node. The required configuration is “-” as separator and then you need to create a list (do not chose to create several new columns). Once the column of type list is created, you would just need to use an -Ungroup- node to ungroup the elements in the list to eventually have them as cells in a single column.

Hope it is clear enough. Otherwise please reach out again and we will help you further.

Best
Ael

4 Likes

Hi @aworker
thank you !
perfect

1 Like