Rename changing column to a standard

KNIME Analytics Platform
#1

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

#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

BR

6 Likes
#3

Indeed, this is what I was looking for.
Many thanks

1 Like