Renaming changing dates in headers

[Luciano-ip]

Hi Team! 

I need to parse a report which has some dates as headers. I would like to rename them to something easier like "Balance". How can I do this taking into account that each day the header will change to a different date? This is to say, today the header would be 12/12/2023 and tomorrow 12/13/2023, etc.

Thanks in advance for your assistance! :)

[binuacs · Accepted solution]

@Luciano-ip The Dynamic Raname tool would be an option for your usecase

[Raj]

IIF(REGEX_Match([_CurrentField_], "^\d{4}-\d{2}-\d{2}$"), "Balance",[_CurrentField_])

please use this in dymanic replace