Hi, I need help in renaming a column name with set of conditions.
Ex: Amt, AMNT, AMount, AT , has to be modified as Amount.
Input can be any one of the above and the output column name has to be Amount. Please help.
Same way, need to remove column’s in a file where the condition should be set as, except a set of headers, rest should be removed.
Thanks in Advance.