converting the date field from dd/mm/yyyy to yyyy/mm/dd

pareshan · #1 (**permalink**) 03-17-2009

How to convert the date field from dd/mm/yyyy to yyyy/mm/dd in unix
my script will generate text file which have two fields
one is date and another is name of the server for example this is sample date which I have to sort based on older to newer date the problem is when I found out sort will work good if i have date format in yyyy/mm/dd

So anyone can help me converting the format from dd/mm/yyyy to yyyy/mm/dd or sort as it is but it should be from older to newer one

11/14/2005 "labqaxm"
11/14/2006 "labqaxm"
11/29/2004 "amadeus"
11/29/2008 "amadeus"
11/29/2004 "betty"
11/29/2004 "dhprrn"
11/29/2009"flash"
11/29/2004 "wilma"
11/29/2004 "wilma"
11/29/2007 "dhprrn"
11/29/2007 "dhprrn"
11/29/2007 "dhprrn"
11/29/2007 "dhprrn"
11/29/2008"dhprrn"
11/29/2007 "dhprrn"
11/29/2006"dhprrn"
11/29/2007 "dhprrn"
11/29/2005"dhprrn"
11/29/2007 "dhprrn"
11/29/2007 "dhprrn"
11/29/2007 "dhprrn"
11/29/2000"dhprrn"
11/29/2007 "dhprrn"
11/29/2007 "dhprrn"
11/29/2010dhprrn"
11/29/2007 "dhprrn"
11/30/2010 "boesky"
11/30/2010 "boesky"

Thank you very much I will really appreciate any help
Im in trouble

vgersh99 · #2 (**permalink**) 03-17-2009

Have you tried searching these forums first?

jim mcnamara · #3 (**permalink**) 03-17-2009

Code:

awk '{
      date=""
      date= substr($1,7,4)  substr($1,4,2) substr($1,1,2)
      print date, $0
    }' filename | sort -n |
    while read date rest
    do
        echo "$rest"
    done > newfile

Goldorakk · #4 (**permalink**) 03-17-2009

Code:

#!/bin/ksh

while read line
do
        echo $line | cut -c1-10 | sed -e 's/\// /g' | read D M Y
        echo $Y/$M/$D$(echo $line | cut -c11-)

done < infile

cfajohnson · #5 (**permalink**) 03-17-2009

Code:

sort -n -k3,3 -k2,2 -k1,1 file

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
convert date format YYYYMMDD to MM/DD/YYYY	nasirgondal	Shell Programming and Scripting	8	04-08-2009 10:56 AM
Perl script to extract last date field (yyyy/mm/dd)	ganapati	Shell Programming and Scripting	1	01-09-2009 12:31 PM
Change Date from dd-mmm-yyyy to mm/dd/yyyy	stringzz	Shell Programming and Scripting	9	09-15-2008 10:09 AM
Date Vadidation in YYYY-MM-DD	itsmehihihi	Shell Programming and Scripting	1	07-22-2007 09:22 PM
sed to display date in dd/mm/yyyy format	sars	Shell Programming and Scripting	2	02-15-2007 03:32 AM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread: