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.