rename many similar attribute

Sadegh95

hi there. i have so many attributes that named "att_1, att_2, ..., att_500". i want to rename them to eg "attribute". how can i do that? Thanks

MartinLiebig

Hey,

have a look at Rename by Replacing. Note that column names need to be unique.

Cheers,

Martin

Sadegh95

I found a way in topics (now couldn't found it) that replace the attributes by combining loop attributes and rename by replacing which can replace attributes to a specific name in one column. i want that way or similar way.

thanks for your regard

MartinLiebig

Sorry, but I do not understand the task at hand.

Sadegh95

sorry

i want to rename many columns. can you give me the regular expression to change my attribute names by "rename by replacing" operators?

MartinLiebig

From

att_1 -> attribute_1

att_2 -> attribute_2

等等?
If so:

att\_(\d+)

replacement with

attribute_$1

should do it