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
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.