Solved Changing the date format in the columns of a CSV file

September 22, 2015 at 09:33:52
Specs: Windows 7
I have a requirement where I need to change the date format of the columns. Here I have provided the input file and the desired output file. Please suggest me a script that will do this work.

Input File:


Required Output File:


Thanks for your help and time..!!

See More: Changing the date format in the columns of a CSV file

Report •

September 23, 2015 at 18:37:50
✔ Best Answer
If you're "allowed" to use vbscript, it's simple. If not, I will defer to those with more patience and/or coding skills. This vbscript snippet does the conversion you want:
'--- begin vbscript
wscript.echo mid(t,1,5)&right(t,2)
'---- end
(at least, it worked on my system with my settings).

Report •
Related Solutions

Ask Question