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 ?
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.
thank you !