Dynamic Column Rename in a Loop

Hi, I have bunch of excel files, which i want to collate but these files column names structured with slight variations. e.g
Data Analyst
Data analyst
Data Analyst (#1)
Data Anlayst
&&
Long Code
LongCode
Longcode

I want to replace 1st one to Data Analyst & 2nd to Long Code.

I tried to use Column rename regex, but its not working for me. Appreciate any help on this

Hi,

In the Search String (regexp) try to use Long.* instead of longcode (and Data.*)

Regards

4 Likes

maybe you can provide some demo files
br

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.