Awk/sed to play on calender


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Awk/sed to play on calender
# 1  
Old 12-24-2012
Awk/sed to play on calender

Hello Awk'inas/Sed'ers;

This is keep ringing on my mind for a while, onto play in calender with awk or sed Smilie. Given a date, month and Year would like to find out the day corresponding to it. Am still a noob on awk and sed, hence would like to learn it from your responses.

Here it is;
Code:
cal 10 1987
       October 1987
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  31

When it is 1, I would like to see the output as Thu. Similarly for other dates would like to see the matching days of it.

PS: One liner will be great and fun. Thanks Smilie
# 2  
Old 12-24-2012
Try sth like this...

Code:
value=1

cal 10 1987 | awk -v var="$value" 'NR==2{n=split($0,P)}
NR>2{for(i=1;i<=7;i++){if(var == $i){print P[7-NF+i]}}}'

This User Gave Thanks to pamu For This Post:
# 3  
Old 12-24-2012
Not sure if this is worth the while...:
Code:
$ for DAY in {1..31}
   do
      cal 10 1987|awk -v day=$DAY \
          'NR==1{next}
           NR==2 {split ($0, WD); next}
           match ($0, "(^| )"day" ") {print day,WD[ int((4+RSTART-RSTART%2)/3)]}
          '
   done
1 Th
2 Fr

You can squeeze all of this into one single line, of course, as e.g. NR==1 can be omitted and the variables can be one letter only, but readability may suffer... see yourself:
Code:
cal 10 1987|awk -v D=$1 'NR==2 {split($0,WD)} R=match($0,"(^| )"D" ") {print WD[int((4+R-R%2)/3)]}'


Last edited by RudiC; 12-24-2012 at 10:41 AM..
# 4  
Old 12-24-2012
You might find the thread Find Day of Week useful.
# 5  
Old 12-25-2012
Quote:
Originally Posted by pamu
Try sth like this...

Code:
value=1

cal 10 1987 | awk -v var="$value" 'NR==2{n=split($0,P)}
NR>2{for(i=1;i<=7;i++){if(var == $i){print P[7-NF+i]}}}'

Pamu, great work... Can you please explain me about the P in split command and the piece P[7-NF+i]
# 6  
Old 12-25-2012
NR==2{n=split($0,P)} means when input record is 2nd (Days of Week) divide all of them and store in an array variable named P
Code:
    October 1987
Su Mo Tu We Th Fr Sa
             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 31

P[7-NF+i]Is the formula pamu used to get the right array index & value to print of the day of week for date entered.
# 7  
Old 12-25-2012
Sorry bipinajith, one more query. I understood they are splitting the columns and storing each value into the array P. Whats the need of n here n=split($0,P).

---------- Post updated at 07:42 AM ---------- Previous update was at 07:31 AM ----------

@RudiC: Thanks for your code, can you please explain me on "(^| )"D" "
How this works.

@Don: I am looking after your thread
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

sed and awk giving error ./sample.sh: line 13: sed: command not found

Hi, I am running a script sample.sh in bash environment .In the script i am using sed and awk commands which when executed individually from terminal they are getting executed normally but when i give these sed and awk commands in the script it is giving the below errors :- ./sample.sh: line... (12 Replies)
Discussion started by: satishmallidi
12 Replies

2. Shell Programming and Scripting

Facing problem while having time popup from inline calender

I have CGI Perl script that contains date column and date popup will be displayed from inline calender. I had a html script for the same and converted the same to CGI script. html page worked fine but no luck with CGI script. Could anyone please look into the below script and let me know... (1 Reply)
Discussion started by: scriptscript
1 Replies

3. Shell Programming and Scripting

Enter number of days and get calender

Friends need assistance in getting a script either on shell or perl. Below is the situation Taking Today's calender into consideration with Month,Day,Year current .Using that i would like give number of days to get its month,day,year for future or past calender depending on the + or - days... (8 Replies)
Discussion started by: ajayram_arya
8 Replies

4. UNIX and Linux Applications

Calender/docket software

We are running in a Linux/Samba environment. Can anyone suggest calendar/docket software that will run in our environment? (0 Replies)
Discussion started by: kbweiss
0 Replies

5. Shell Programming and Scripting

Awk with Find and play using Space

Hi All, Sample records 2157 91128 -rw-r----- 1 arun1 staff 93315072 Aug 23 06:44 /home/arun/my own/file_name.txt 2157 91128 -rw-r----- 1 arun1 staff 93315072 Aug 23 06:44 /home/arun/myown/file name2.txt i want to print only user name, user group, size, date time stamp, and... (5 Replies)
Discussion started by: Arunprasad
5 Replies

6. Shell Programming and Scripting

Question on Autosys calender date.

Hi I am trying to schedule a job through Autosys through UNIX on a particular day of every month (for example 20th of every month). Can some one please help me whats the command or whats the process to run on that particular day of month. Thank you, (2 Replies)
Discussion started by: sravuri
2 Replies

7. Fedora

Script to find out first day of our calender

I try to find the first day of our calender. So I used this script ... echo -n "The week of the date 01jan0001 : " echo -n `date -d 00010101 +%A` echo But its shows error bash-3.1$ sh first_day.shThe week of the date 01jan0001 : date: invalid date `00010101' (3 Replies)
Discussion started by: krishnampkkm
3 Replies

8. Shell Programming and Scripting

Calender Unix programming date issues

Hi, i;m beginner of Unix, i trying to use crontab to zip my log file automatically, below is my coding, some of the statement i don't know whether is correct or not. Pls help:) year=`date '+%Y'` month=`date '+%m'` day=`date '+%d'` day=`expr $day - 1` case $month in 1 | 3 | 5 | 7 | 8 | 9 |... (4 Replies)
Discussion started by: dannyd_y
4 Replies

9. Shell Programming and Scripting

convert Julian date to calender date

Hi, I have script in unix which creates a julian date like 126 or 127 I want convert this julian date into calender date ex : input 127 output 07/may/2007 or 07/05/2007 or 07/05/07 rgds srikanth (6 Replies)
Discussion started by: srikanthus2002
6 Replies

10. Programming

C Calender Help - Unusual error

I'm making a program that you input the month and year, and it creates a calender for that month of that year. This is my largest project yet, and I broke it up into several source files. cal.c #include "cal.h" #include <stdio.h> main() { int month, year; scanf("%d %d", &month,... (3 Replies)
Discussion started by: Octal
3 Replies
Login or Register to Ask a Question