Hi,
I'm trying to create a macro that can read medical records and automatically return an estimate of duration based on a diagnosis. The files I'm reading come from multiple sources and therefore don't have consistent column names or titles. Most of them contain the strings "PRI" and "DIAGNOSIS". What is the best way to look for a column containing those strings (even if there are other strings between them) and rename them all to "Primary Diagnosis" for use in the macro?
Thanks!
