Incrementing column names after Cell Splitter node
Hi folks,
I’ve used a Cell Splitter node to split a column that contained a comma delimited list. The output was as follows:
I need the output columns to ultimately be named:
LithMin1, LithMin2, Lith_Min3, etc.
I can get rid of the _Arr[ & ] parts using a Column Rename (Regex) node. That works fine. But how do I increment the numeric portion of the column name, such that it starts with 1 and not 0?
I’m trying to do this dynamically, to work for a variety of different column names, so I don’t want to just hardwire a Column Renamer node.
Alternatively, is it possible to set the Cell Splitter to start it’s column numbering at 1 instead of 0? That would be even better.