Column Rename Regex
Hello everyone!
In an excel file I have a column that is renamed “Portofoliul initial-retrasi (#90)”. On the next run of the flow, this column will be called “Portofoliul initial-retrasi (#91)”. As a rule, every time the flow is run, this column will have +1 added to the digits in the column name. I want to rename this column with “Portofoliul initial-retrasi”, but I can’t. I tried the Column Rename(Regex) node with the following configuration: searchstring: "(?i)Portofoliul\sinitial-retrasi\s(#\d+) " ; replacement: “Portofoliul initial-retrasi” but it does not work.
Is there another option?
Have a nice day!