Can You Replace a Specific String in a Column Header

Question

I have the column headers

And the want to replace just the string in the below Image with the actual numerical months (ie 2025-09)

I know dynamic rename will replace if the column header matches exactly, but I just want the string portion matched.

griffinwelsh · Accepted Answer

See the attached solution. You can use the replace tool after transposing your data and then reassemble your table with cross tab.

SPetrie · Accepted Answer

If I understand the ask, you can use the field info tool to grab your original header names, and a formula tool to copy them to create a new name field. Use Find and replace to create your updated field names and then dynamic rename to update them.

Qiu · Accepted Answer

@briankuhlmann 
Maybe its something like this if I understand your intention correctly?

flying008 · Accepted Answer

Hi, @briankuhlmann

The 2 solutions for you as below:

Spoiler

'2025-' + 
PadLeft(ToString(ToNumber(Left([_CurrentField_], 1)) + 8), 2, '0') + REGEX_Replace([_CurrentField_], '^\dMonth', '_')