Sponsored Content
Top Forums Shell Programming and Scripting Getting a specific date from cal output with AWK Post 302380933 by SFNYC on Wednesday 16th of December 2009 04:57:22 PM
Old 12-16-2009
If you have Perl and the Date::Manip module installed you can try this:

Code:
$ perl -le 'use Date::Manip;print UnixDate(ParseDate("1st Monday in December 2009"), "%d");'
07

$ perl -le 'use Date::Manip;print UnixDate(ParseDate("3rd Friday in December 2009"), "%d");'
18

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Formating cal output

Hi Gurus, In my Cal output i want to cut the date of 2nd saturday how tyo achive this. for eg in the below output i need that second saturday 13 to be cut. crypto $ cal January 2007 S M Tu W Th F S 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26... (2 Replies)
Discussion started by: Krrishv
2 Replies

2. UNIX for Advanced & Expert Users

Get date from cal function

Cal Sun Mon Tue Wed Thu Fri Sat 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 cal | awk '{print $7}' Sat 13 20 27 In the above output i am missing 6 because the first column is empty so it is shfting. How... (3 Replies)
Discussion started by: ukatru
3 Replies

3. Red Hat

how to print date/cal in /etc/motd on linux server

helo i want to show today date and calendar when v succesfuly login on the system on the linux server please orovide the sol for the same thanx :):):) (1 Reply)
Discussion started by: dodasajan
1 Replies

4. Shell Programming and Scripting

awk statement to find events from a specific date

I have a script which archives log file events which are 90-days old. Script works fine but I wanted some input on one aspect of this script. My nawk statement, bolded below, that removes events 90-days prior from today, I need it to find anything 90-days or older. The log file date pattern looks... (0 Replies)
Discussion started by: numele
0 Replies

5. Shell Programming and Scripting

Center output of 'cal' command in terminal

I have a function to center output in a terminal. However It only works for variables. I would like to center the output of the command 'cal' or 'cal -3' in a terminal. I have tried: center `cal` CAL=`cal`; center $CAL cal > cal.txt; center `cat cal.txt` center "`exec cal`" To no avail,... (10 Replies)
Discussion started by: AlphaLexman
10 Replies

6. Shell Programming and Scripting

awk assign output of array to specific field-number

With this script i want to print the output to a specific field-number . Can anybody help? awk 'NR=FNR{split(FILENAME,fn,"_");nr=$2;f = $1} END{for (i=1;i<=f;i++) print i,$fn=nr}' input_5.csv input_6.csvinput_5.csv 4 135 5 185 6 85 11 30input_6.csv 1 90 3 58 4 135 7 60 8 55 10... (1 Reply)
Discussion started by: sdf
1 Replies

7. Shell Programming and Scripting

Find and print specific date with awk

hi all I would like to help me find the problem with this script to find and print to the screen a specific date of a log file that I have on my server, the date it is received as the first argument in the script $ 1 Here I show you a few lines that made ​​the idea of ​​my log file: ****... (4 Replies)
Discussion started by: gilmore666
4 Replies

8. Shell Programming and Scripting

AWK specific output filename

Hi All, I'd like to create a specific output filename for AWK. The file I am processing with AWK looks like: output_081012.csv* 27*TEXT*1.0*2.0*3.0 where * is my delimeter and the first line of the file is the output filename i'd like to create is there a way to assign an awk... (10 Replies)
Discussion started by: LMSteed
10 Replies

9. Shell Programming and Scripting

awk to output specific matches in file

Using the attached file, the below awk command results in the output below: I can not seem to produce the desired results and need some expert help. Thank you :). awk -F'' ' { id += $4 value += $5 occur++ } END{ printf "%-8s%8s%8s%8s\n", "Gene", "Targets", "Average Depth", "Average... (3 Replies)
Discussion started by: cmccabe
3 Replies

10. Shell Programming and Scripting

awk to output match and mismatch with count using specific fields

In the below awk I am trying output to one file those lines that match between $2,$3,$4 of file1 and file2 with the count in (). I am also trying to output those lines that are missing between $2,$3,$4 of file1 and file2 with the count of in () each. Both input files are tab-delimited, but the... (7 Replies)
Discussion started by: cmccabe
7 Replies
Date::Manip::Examples(3pm)				User Contributed Perl Documentation				Date::Manip::Examples(3pm)

NAME
Date::Manip::Examples - examples of how to use Date::Manip DESCRIPTION
This document includes a number of examples on how to do common Date::Manip operations. I will be happy to add new examples over time, and welcome suggestions and examples to include. In most cases, an example will include two different ways of getting the answer. The first way will be using the new (as of 6.00) OO modules. The second will be using the old-style functional interface. It should be noted that any time you want to work with alternate time zones, the OO interface is STRONGLY recommended since the functional interface does not preserve time zone information with the date, and may therefore give incorrect results in some cases. However, working in the time zone of the system should give correct results. It should be noted that, in the examples below, it appears that the OO method often requires more lines of code than the functional interface. There are a number of ways to shorten the OO method, but for the examples, I wanted to include all the steps explicitly. PARSING A DATE
Dates can be parsed in practically any form in common usage: OO method $date = new Date::Manip::Date; $err = $date->parse("today"); $err = $date->parse("1st Thursday in June 1992"); $err = $date->parse("05/10/93"); $err = $date->parse("12:30 Dec 12th 1880"); $err = $date->parse("8:00pm December tenth"); Functional $date = ParseDate("today"); $date = ParseDate("1st Thursday in June 1992"); $date = ParseDate("05/10/93"); $date = ParseDate("12:30 Dec 12th 1880"); $date = ParseDate("8:00pm December tenth"); The Date::Manip::Date manual has a list of all valid formats. PARSING AN AMOUNT OF TIME
Amounts of time (referred to as deltas) can also be parsed: OO method $delta = new Date::Manip::Delta; $err = $delta->parse("in 12 hours"); $err = $delta->parse("-1:30:0"); $err = $delta->parse("4 business days later"); Functional $delta = ParseDateDelta("in 12 hours"); $delta = ParseDateDelta("-1:30:0"); $delta = ParseDateDelta("4 business days later"); TO CALCULATE THE AMOUNT OF TIME BETWEEN TWO DATES
$datestr1 = "Jan 30 1999 13:00 EST"; $datestr2 = "2/Mar/1999 15:30:00 +0500"; OO method $date1 = new Date::Manip::Date; $date2 = $date1->new_date(); $err = $date1->parse($datestr1); $err = $date2->parse($datestr2); To get an exact amount of time between the two dates (expressed only in terms of weeks, days, hours, minutes, seconds), use: $delta = $date1->calc($date2); To get an approximate amount of time (expressed in terms of years, months, weeks, etc. in terms that a human would typically think of), use: $delta = $date1->calc($date2,"approx"); Functional $date1 = ParseDate($string1); $date2 = ParseDate($string2); To get an exact amount: $delta = DateCalc($date1,$date2); and the approximate amount: $delta = DateCalc($date1,$date2,1); The Date::Manip::Calc manual has information about these, and other types of calculations. TO ADD AN AMOUNT OF TIME TO A DATE
To find a second date a given amount of time before or after a first date, use the following: $datestr = "Jan 30 1999 13:00 EST"; $deltastr = "12 hours ago"; $deltastr = "in 3 business days"; OO method $date = new Date::Manip::Date; $delta = $date->new_delta(); $date->parse($datestr); $delta->parse($deltastr); $d = $date->calc($delta); Functional $date = DateCalc($datestr,$deltastr); If the delta is a business delta, it will do a business mode calculation. The Date::Manip::Calc manual has information about these, and other types of calculations. COMPARE TWO DATES
To take two different dates and see which is earlier, do the following: $datestr1 = "Jan 30 1999 13:00 EST"; $datestr2 = "2/Mar/1999 15:30:00 +0500"; OO method $date1 = new Date::Manip::Date; $date2 = $date1->new_date; $date1->parse($datestr1); $date2->parse($datestr2); $date1->cmp($date2); => -1, 0, 1 Functional $date1 = ParseDate($datestr1); $date2 = ParseDate($datestr2); Date_Cmp($date1,$date2); => -1, 0, 1 TO EXTRACT INFORMATION ABOUT A DATE OR DELTA
If you have a date or a delta, you can extract information about them as follows: $datestr = "1:24:08 PM EST Feb 3, 1996"; $deltastr = "12 hours ago"; OO method $date = new Date::Manip::Date; $delta = $date->new_delta(); $date->parse($datestr); $delta->parse($deltastr); $date->printf("It is now %T on %b %e, %Y."); => "It is now 13:24:08 on Feb 3, 1996." $delta->printf("In %hv hours, %mv minutes, %sv seconds"); => "In -12 hours, 0 minutes, 0 seconds"; Functional UnixDate($datestr,"It is now %T on %b %e, %Y."); => "It is now 13:24:08 on Feb 3, 1996." Delta_Format($deltastr,"In %hv hours, %mv minutes, %sv seconds"); => "In -12 hours, 0 minutes, 0 seconds"; The Date::Manip::Date manual contains all of the format codes that can be used to extract information from a date. The Date::Manip::Delta manual contains the codes for a delta. WORKING WITH EPOCH
Date::Manip can easily be used to work with the number of seconds since the epoch (Jan 1, 1970 00:00:00 UTC). If you have a date, and you want to find out how many seconds it is after the epoch, you can do it in the following ways: $datestr = "1999-04-30-15:30:00 EDT"; $secs = 1234567; OO method To find out how many seconds have elapsed on a certain date, you can do the following: $date = new Date::Manip::Date; $err = $date->parse($datestr); $date->printf('%s'); => number of seconds To find out the date that is a certain number of seconds since the epoch, you can use the following: $date = new Date::Manip::Date; $err = $date->parse("epoch $secs"); $date now contains the date wanted (in the local time zone) Functional To find out how many seconds have elapsed: UnixDate($datestr,'%s'); => number of seconds To find the date that is a number of seconds since the epoch: ParseDateString("epoch $secs"); Note that Date::Manip will work with both positive seconds (for dates that have come since the epoch) and negative seconds (for dates that occurred before the epoch). RECURRING EVENTS
To find a list of dates where a recurring event happens (even very complex recurrences), do the following: OO method # To find the 2nd Tuesday of every month from Jan 1 1999 to Apr 30 1999 $recur = new Date::Manip::Recur; $start = $recur->new_date(); $end = $recur->new_date(); $start->parse("Jan 1 1999"); $end->parse("Apr 30 1999"); $recur->parse("0:1*2:2:0:0:0",$start,$end); @date = $recur->dates(); # To find the Monday after Easter in 1997-1999 $recur = new Date::Manip::Recur; $recur->parse("*1997-1999:0:0:0:0:0:0*EASTER,ND1"); @date = $recur->dates(); Functional # To find the 2nd Tuesday of every month from Jan 1 1999 to Apr 30 1999 @date = ParseRecur("0:1*2:2:0:0:0","","Jan 1 1999","Apr 30 1999"); # To find the Monday after Easter in 1997-1999. @date = ParseRecur("*1997-1999:0:0:0:0:0:0*EASTER,ND1"); The Date::Manip::Recur manual contains information about recurring events. WORKING WITH DATES IN ANOTHER LANGUAGE
If you want to work with dates in a language other than English (but you are only working with a single language), do the following: OO method $date = new Date::Manip::Date; $date->config("Language","French","DateFormat","non-US"); $date->parse("1er decembre 1990"); Functional Date_Init("Language=French","DateFormat=non-US"); $date = ParseDate("1er decembre 1990"); The Date::Manip::Config manual has a list of all supported languages (in the section on the Language config variable). The meaning of the DateFormat config variable is also included. WORKING WITH TWO DIFFERENT LANGUAGES
If you want to work with dates in two (or more) languages, it is STRONGLY recommended that you use the OO interface. The functional interface will be much slower since it has to re-initialize a lot of language-specific stuff every time you switch back and forth between languages. OO method $date_eng = new Date::Manip::Date; $date_eng->config("Language","English","DateFormat","US"); $date_fre = new Date::Manip::Date; $date_fre->config("Language","French","DateFormat","non-US"); Use the $date_eng object to do English operations, the $date_fre object to do French operations. Functional If you are working with both French and English dates, you can call the following to switch between them: Date_Init("Language=French","DateFormat=non-US"); Date_Init("Language=English","DateFormat=US"); This is NOT recommended. Use the OO method instead. BUGS AND QUESTIONS
Please refer to the Date::Manip::Problems documentation for information on submitting bug reports or questions to the author. SEE ALSO
Date::Manip - main module documentation LICENSE
This script is free software; you can redistribute it and/or modify it under the same terms as Perl itself. AUTHOR
Sullivan Beck (sbeck@cpan.org) perl v5.14.2 2012-06-02 Date::Manip::Examples(3pm)
All times are GMT -4. The time now is 10:38 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy