Formating Date in Text file

[Nabil_2]

Hello,
I am working on a project to load a text file in an MYSQL database and looking for some Unix commands that could assist me in changing the Date format in my text file.

Here is how the text file look like:


1 test test1 test2 test3 07-09-2002 test5
1 test test1 test2 test3 07-05-2002 test5
1 test test1 test2 test3 07-03-2002 test5
1 test test1 test2 test3 07-01-2002 test5
1 test test1 test2 test3 07-04-2002 test5


something like that and would like to change the date part to look like this format yyyy-mm-dd


Can any one help me with this ???

Thanks for any help

[A. Clay Stephenson · Accepted solution]

This is probably most easy to handle in awk.

The attached 2 minute script creates an awk script 'on the fly' and executes it.

Use it like this:
format.sh oldfile > newfile

[Nabil_2]

WOW, Thank you ... that worked like a charm ..Perfect result ....


Thank you again .. This works for me....