How do I dynamically identify a column based off of Regex

[sp210708]

I created a sample Input file. The input file will be different every time as it comes from external vendors. (so I can't use position of column or column names)

I'm close to a solution from a logic perspective but missing some pieces.

Ultimately I need to dynamically identify which column is the one with Zip codes (5 digits in a row) and then rename it to a common name say "ZIP CODES" so then I can use that moving forward with my workflow.

Multiple columns could contain 5 digits in a row so I need to something along the lines of counting the times a regex matches and then sorting the columns to figure out which one is the column needed to rename.

Thanks,

Shane

[alexnajm]

Sounds like a Dynamic Rename tool and applying the logic there with Rename Mode = Formula! Once you figure out the logic let us know so we can try to help.

[FinnCharlton · Accepted solution]

Hi @sp210708 , here's one approach: