Finding Day of the week from date Post: 302461390

Sponsored Content

Top Forums Shell Programming and Scripting Finding Day of the week from date Post 302461390 by junaid.nehvi on Monday 11th of October 2010 03:41:31 AM

10-11-2010

Registered User

Thanks all for you replies:

On my solaris machine date -d doesn't work.
Niether does date -j -f... Smilie

(

Franklin52: I have to do this process (dow) for every record in a file, besides other fuctions that are to be performed on other fields of data.

I have written a piece of code as:

Code:

awk 'BEGIN{
	FS="|";
	while(getline < "DAY_MAPPING_NEW.CFG")
	{
	DAY_NEW[$2]=$1; DAY_NEW[$3]=$1; DAY_NEW[$4]=$1; DAY_NEW[$5]=$1; DAY_NEW[$6]=$1; DAY_NEW[$7]=$1;
	}
}
{
	dd=substr("'${DATE}'",7,2);
	mm=substr("'${DATE}'",5,2);
	yyyy=substr("'${DATE}'",1,4);
	system("cal "mm" "yyyy" | tail -7|tr \" \" \";\"|tr \"\\n\" \";\" >out.txt");
	while(getline < "out.txt")
	{OPFILE=$0;}
	if (int(dd) <= 9) {	dd=substr("'${DATE}'",8,1);	}
	newdd=";"dd";"
	daynum=index(OPFILE,newdd);
	print "New Date is:"dd"|"mm"|"yyyy"|"DAY_NEW[daynum];
	system("rm out.txt");


	OTHER FUNCTIONALITIES
		.
		.
		.
		.
		..
		..
		.
		.
		..
}' INPUTFILE.txt

But i want to get output of system commant in some variable rather than writting o/p in a file "out.txt' and removing it everytime.

Last edited by Scott; 10-11-2010 at 06:58 AM.. Reason: Code tags, please...

junaid.nehvi

View Public Profile for junaid.nehvi

Find all posts by junaid.nehvi

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Changing First Day Of The Week?

Hi All, Our system is running on Solaris 8 and we are using US locale. By default the First Day Of Week is Sunday, is it possible for us to change it to Monday? I have googled it but found very little of use. THanks in advance.

2. UNIX for Dummies Questions & Answers

How to find Day of the Week from the given date (Perl)?

How to find the Day of the Week of the given Date using perl? If I have a date in YYY--MM-DD format, how to find the DOW? Based on that, I need to find the following sunday. Pls help.

3. HP-UX

Get Day of Week from date

Hi All, I have date in string format 'YYYY-MM-DD'. I want to know day of the week for this date. Example. For '2005-08-21' my script should return '0' or Sunday For '2005-08-22' it should return '1' or Monday I want piece of code for HP-UX korn shell. Appreciate reply on this.

4. Shell Programming and Scripting

Function to get day of week from YYYY-MM-DD date

Can't find out how to get the day of the week from a given date, anyone got a code snippet that could help please? Ta!!

5. Shell Programming and Scripting

how to obtain date and day of the week from `date` command

Hi, does anybody know how to format `date` command correctly to return the day of the week? Thanks -A I work in ksh....

6. Shell Programming and Scripting

finding the previous day date and creating a file with date

Hi guys, I had a scenario... 1. I had to get the previous days date in yyyymmdd format 2. i had to create a file with Date inthe format yyyymmdd.txt format both are different thanks guys in advance..

7. Shell Programming and Scripting

How to add day of week at the end of each line that shows the date?

I have a file that looks like: file1: www_blank_com 20121008153552 www_blank_com 20121008162542 www_blank_com 20121009040540 www_blank_com 20121009041542 www_blank_com 20121010113548 www_blank_com 20121011113551 www_blank_com 20121012113542 I want the new file to show the day of...

8. Shell Programming and Scripting

How to obtain a day of the week from the date?

I have a date in format YYYYMMDD, i need to get the day of the week from the given date. I am working in AIX system. ---------- Post updated at 09:59 AM ---------- Previous update was at 09:57 AM ---------- Tried to post sum of the thread's link from which i tried, but de rules didnt allow me...

9. Shell Programming and Scripting

How to get the consecutive last 10 week day date using UNIX ksh shell scripting?

Hi, i am writing a ksh shell script to check the last month end date whether it is falling in last 10 week day date, I am not sure How to use "Mr. Perderabo's date calculator", Could you Please let me know how to use to get my requirement, I tried my own script but duplicate week day and...

10. Shell Programming and Scripting

Get the week's day

Hi All, I have the below requirement , if i give the week number for ex 41 i need to get the date for Monday and thursday for this given week. my expected output is 13/10/2014 (Monday's date) and 16/10/2014 (Thursday's date) I am using GNU LINUX . Pls help me with your thoughts. Thanks in...

LEARN ABOUT PHP

cal_from_jd

CAL_FROM_JD(3)								 1							    CAL_FROM_JD(3)

cal_from_jd - Converts from Julian Day Count to a supported calendar

SYNOPSIS

       array cal_from_jd (int  $jd, int  $calendar)

DESCRIPTION

       cal_from_jd(3)  converts  the Julian day given in $jd into a date of the specified $calendar. Supported $calendar values are CAL_GREGORIAN,
       CAL_JULIAN, CAL_JEWISH and CAL_FRENCH.

PARAMETERS

	      o $jd
		- Julian day as integer

	      o $calendar
		- Calendar to convert to

RETURN VALUES

	Returns an array containing calendar information like month, day, year, day of week, abbreviated and full names of weekday and	month  and
       the date in string form "month/day/year".

EXAMPLES

       Example #1

	      cal_from_jd(3) example

	      <?php
	      $today = unixtojd(mktime(0, 0, 0, 8, 16, 2003));
	      print_r(cal_from_jd($today, CAL_GREGORIAN));
	      ?>

	      The above example will output:

	      Array
	      (
		  [date] => 8/16/2003
		  [month] => 8
		  [day] => 16
		  [year] => 2003
		  [dow] => 6
		  [abbrevdayname] => Sat
		  [dayname] => Saturday
		  [abbrevmonth] => Aug
		  [monthname] => August
	      )

SEE ALSO

       cal_to_jd(3), jdtofrench(3), jdtogregorian(3), jdtojewish(3), jdtojulian(3), jdtounix(3).

PHP Documentation Group 													    CAL_FROM_JD(3)

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Changing First Day Of The Week?

Discussion started by: fowlerleftfoot

2. UNIX for Dummies Questions & Answers

How to find Day of the Week from the given date (Perl)?

Discussion started by: deepakwins

3. HP-UX

Get Day of Week from date

Discussion started by: vpapaiya

4. Shell Programming and Scripting

Function to get day of week from YYYY-MM-DD date

Discussion started by: couponmeup