topic Re: Converting date in a shell script in Operating System - HP-UX

Converting date in a shell script

Timothy P. Jackson — Mon, 29 Oct 2007 17:12:04 GMT

I am developing a shell script that needs to accept multiple date formats and be able to convert them into the long date format.

Example:

10/29/07 ---> 29 October 2007
10-29-2007 ---> 29 October 2007
10.29.07 ---> 29 October 2007

etc.....

I need this so that I can grep out information from the certian log files. Because this is going to be run by normal users I am not sure if I can get them to enter the date the same time, every time.

Does any one have suggestions or recommendations on how to do this?

Thanks,
Tim

Re: Converting date in a shell script

blah2blah — Mon, 29 Oct 2007 17:17:33 GMT

use Clay Stephenson's 'caljd' date manipulation utility!

You can download it from Merijn's website:

http://mirrors.develooper.com/hpux/

Re: Converting date in a shell script

Timothy P. Jackson — Mon, 29 Oct 2007 18:02:21 GMT

Thanks,

I down loaded it but I am have some diffulty with the syntax. Is there a "help" with Clay's utility?

Tim

Re: Converting date in a shell script

blah2blah — Mon, 29 Oct 2007 18:47:40 GMT

either -u or -? will generate a usage message

Re: Converting date in a shell script

Timothy P. Jackson — Mon, 29 Oct 2007 19:41:16 GMT

Ok, I got the date to convert to a Julian Date, but now I need to convert it back a specific format of.....

Mon Oct 29 ... ... ...

this would be the same format that the "date" command would give.

Maybe there is an easier way to do this. I need to get all the entries out of the br_log file for the past 3 months, or from any give date forward.

Re: Converting date in a shell script

blah2blah — Tue, 30 Oct 2007 10:01:52 GMT

just replying to return to top of queue.

maybe someone familiar with clay's date tool can provide further examples in how to do this

Re: Converting date in a shell script

Timothy P. Jackson — Tue, 30 Oct 2007 10:09:49 GMT

Thanks for following up on this. Clay's date converter utility works great. I spent some time with his examples and found what I needed. I also found that to create a script to pull this information out of the br_log file was going to take a lot longer than it was worth.

So I imported the br_log file into Excell and striped out the data that I didn't want. This should make management happy.

Thanks again!

Tim

Re: Converting date in a shell script

Timothy P. Jackson — Tue, 30 Oct 2007 10:11:13 GMT

See above reply

Re: Converting date in a shell script

A. Clay Stephenson — Tue, 30 Oct 2007 10:18:58 GMT

This is really not a task for caljd.sh (or caljd.pl); your problem is tailor-made for the ParseDate function of the Perl Date::Manip module. Date::Manip is available from any CPAN site. ParseDate can recognize many different input formats and convert it to YYYYMMDDHH:MM:SS. Converting to another format is quite simple from that output.

Re: Converting date in a shell script

Wim Rombauts — Tue, 30 Oct 2007 10:22:59 GMT

Although Clay's tool may be magnificent, I still wonder what is wrong with the date command :
date +"%d %B %E" return (TMHO) exactly what you look for.

Re: Converting date in a shell script

Timothy P. Jackson — Tue, 30 Oct 2007 10:30:38 GMT

Thanks for the information Clay.

When I have some more time I will persue this option. For now Excel will have to job. It is kind of funny that there has not been a utility to sort this information out already created.

Re: Converting date in a shell script

A. Clay Stephenson — Tue, 30 Oct 2007 11:31:33 GMT

The thought of a poor defenseless UNIX box being forced to use Excel is more than my heart can bear. It took me all of about 3 minutes to throw together this Perl sample.

Since you changed your requirements from the 1st example to the 2nd example, I decided to output 2 lines for each input argument.

date.pl "10/29/07" "10-29-2007" "10.29.07" "Oct 10, 2007"

should all be handled with ease. You will need to install the Date::Manip module and that will take you about 4 minutes to download and install from www.perl.org/CPAN.

You should be able to take this and run with it even if you make your Perl script a blackbox that is called by a shell script.

Re: Converting date in a shell script

Timothy P. Jackson — Tue, 30 Oct 2007 14:01:44 GMT

Thanks Clay, this is awesome!

I too was thinking the same thing as I imported the br_log file into Excel. Its a sad day when I have to use MS to do my work for me.

Thanks again for all your help.

Tim