script to change the date format in a file - Shell Programming and Scripting

shehzad_m · #1 (**permalink**) 06-09-2008

i have many files with date format of 6-9-2008 and i want a script that can change the format to 2008-06-09

Thanks

fpmurphy · #2 (**permalink**) 06-10-2008

Unless you provide an example of one or more of the files, it is difficult for anybody to help you.

penchal_boddu · #3 (**permalink**) 06-10-2008

Hi

echo "6-9-2008" | sed 's/\(.\)-\(.\)-\(.*\)/\3-0\2-0\1/g'

It would be nice if u provide one file as an example as fpmurphy suggested.

Thanks
Penchal

shehzad_m · #4 (**permalink**) 06-10-2008

Here are few examples

NO1A_iCP0041 52 6-9-2008 11 11 8
8

NO1A_iCP0041 52 6-11-2008 11 11 8 8

NO1A_iCP0041 52 9-20-2008 11 11
8 8

The dates are in M-D-YYYY format, I am trying to get it in a YYYY-MM-DD

Thanks

robotronic · #5 (**permalink**) 06-10-2008

Given this input file:

Code:

NO1A_iCP0041 52 6-9-2008 11 11 8 8
NO1A_iCP0041 52 6-11-2008 11 11 8 8
NO1A_iCP0041 52 9-20-2008 11 11 8 8

Try:

Code:

awk '{ split($3, d, "-"); $3=sprintf("%04d-%02d-%02d", d[3], d[1], d[2]); print }' input_file.txt

shehzad_m · #6 (**permalink**) 06-10-2008

Quote:

Originally Posted by robotronic

Given this input file:

Code:

NO1A_iCP0041 52 6-9-2008 11 11 8 8
NO1A_iCP0041 52 6-11-2008 11 11 8 8
NO1A_iCP0041 52 9-20-2008 11 11 8 8

Try:

Code:

awk '{ split($3, d, "-"); $3=sprintf("%04d-%02d-%02d", d[3], d[1], d[2]); print }' input_file.txt

What would i change when the data is pipe delimted

example

NO1A_iCP0041|52|11|11|8|8|6-9-2008
NO1A_iCP0041|52|11|11|8|8|6-11-2008
NO1A_iCP0041|11|11|8|8||52 9-20-2008

Thanks for the help

shehzad_m · #7 (**permalink**) 06-10-2008

Quote:

Originally Posted by shehzad_m

What would i change when the data is pipe delimted

example

NO1A_iCP0041|52|11|11|8|8|6-9-2008
NO1A_iCP0041|52|11|11|8|8|6-11-2008
NO1A_iCP0041|11|11|8|8||52 9-20-2008

Thanks for the help

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Change of date format	svenkatareddy	Shell Programming and Scripting	2	05-22-2008 11:58 PM
How Can we change the Date format from Variable	laknar	Shell Programming and Scripting	1	05-01-2008 11:47 PM
Move A File With Same Date,don't Change The Desitination Dir Date	jee.ku2	UNIX for Dummies Questions & Answers	1	01-09-2008 09:42 AM
Change date format	ust	UNIX for Advanced & Expert Users	4	12-19-2007 01:17 PM
How to change it to the date format	preethgideon	UNIX for Dummies Questions & Answers	3	11-02-2006 04:11 AM

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode