Hi All, Hi could I manage to rename a column that has a name like this: “Field_123456” where the numbers are changing simply to “Field” ? Thank you

Hello @HarryKl [image] Renaming a column based on a condition KNIME Analytics Platform Hi @rpaulorodio & welcome to the KNIME forum This can be easily done using a -Column Rename (Regex)- node: [image] Please be aware that column names must be unique and therefore this is only valid if you have ONLY one column named “Column (something)”. For instance, this solution would not be valid if you have two columns named “Column (#1)” and “Column (#2)”. Hope it helps. Best Ael I think that this Column Rename (Regex) node is what you are looking for. You can test the following code: Search String (regexp): Field(.+) Replacement: Field BR

Rename changing column to a standard

KNIME Analytics Platform

gonhaddock January 23, 2023, 5:58pm 2

Hello @HarryKl

I think that this Column Rename (Regex) node is what you are looking for. You can test the following code:

Search String (regexp):
Field(.+)
Replacement:
Field

6 Likes