How to rename many fields one time?

[NPR]

For example, I have:
field_name0_NPR_pc field_name1_NPR_pc field_name2_NPR_pc ... field_namen_NPR_pc
I want change as this:
field_name0_NPR_pc as name0
field_name1_NPR_pc as name1
field_name2_NPR_pc as name2
...
field_namen_NPR_pc as namen
I've tried this:

...|rename field_name0_NPR_pc as name0|rename field_name1_NPR_pc as name1|...|field_namen_NPR_pc as namen|.. 

But it is very laborious.
How can I do it?

Thanks

[fdi01 · Accepted solution]

try like this:

...|rename field_*_NPR_pc as *|.. 

[NPR]

very thank.

[ngatchasandra]

Hi,

Try with this

  ...|rename field_name*_NPR_pc as name*| table name*

[NPR]

thank for your approach
but name is no the same.