I have a bunch of csv files located in C:\csv
I need to make sure that column I & M have the YYYYMMDD value. The rest of values will remain the same.
The idea is to have script which reads the various files in C:\csv, generates revised version of files as specified in previous point (YYYYMMDD value for column I & M) in C:\out .
Columns involved by the change I & M should be related to a variable.
I attached dummy file.
If you have questions, please contact me.
Thank you in advance for your help.