Only numbers in field name

[BautistaC888]

Hello,
I need an expression that leave only the numbers in the fields names.
Thank you.

[DataNath · Accepted solution]

Hey @BautistaC888, you can use the Dynamic Rename tool for this. The expression here replaces any non-digit (\D) with nothing.

[mceleavey]

Hi @BautistaC888 ,

Another way is to pivot the names into a column and use regex to parse the digits, then pivot back:

Hope this helps,

M.