Find week of the year for given date using date command inside awk Post: 302902333

Sponsored Content

Top Forums Shell Programming and Scripting Find week of the year for given date using date command inside awk Post 302902333 by vijaidhas on Tuesday 20th of May 2014 04:16:22 AM

05-20-2014

Registered User

Quote:

Originally Posted by clx

Try

Code:

awk -v woy="$(date -d "$rt_date" +%-V)" -F"," 
'BEGIN { #some variable assignment}

{ #some calculation and put values in array}

END {
   year=#getting it from array and assume this will be 2014
   month=#getting it from array and this will be 05
   date=# getting it from array and this will be 20

   rt_date=year"-"month"-"woy (this will be 2014-05-20)

Hi Clx,

thanks for your reply.. I think my explanation might have given misunderstanding on the requirement.

let me explain again here.

I am getting the date string inside awk command as 2014-05-20
I need to get the week for this date.

assigning a global variable in awk is not giving me the correct week count for this date.

background:
> I am passing a csv file to this awk command. For each line there would be different date (it may not be the current date or same date).
> So using the date command or any in-build function of awk, i need to get the week for that date.

so can anyone kindly help on this... ???

Please let me know if you need any additional information.

Last edited by vijaidhas; 05-20-2014 at 05:22 AM..

vijaidhas

View Public Profile for vijaidhas

Find all posts by vijaidhas

7 More Discussions You Might Find Interesting

1. 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.

2. 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....

3. Shell Programming and Scripting

Date One Week Ago From Given Date, Not From Current Date

Hi all, I've used various scripts in the past to work out the date last week from the current date, however I now have a need to work out the date 1 week from a given date. So for example, if I have a date of the 23rd July 2010, I would like a script that can work out that one week back was...

4. Shell Programming and Scripting

Extract week start,end date from given date in PERL

Hi All, what i want to do in perl is i should give the date at run time .Suppose date given is 23/12/2011(mm/dd/yyyy) the perl script shold find week start date, week end date, previous week start date,end date,next week start date, end date. In this case week start date will be-:12/19/2011...

5. Shell Programming and Scripting

Help in using date command inside awk

Hi All, bash-3.2$ autorep -J BOX_NAME% -l0 | grep BOX_NAME| awk -f awkScript.awk sh: -c: line 0: unexpected EOF while looking for matching `"' sh: -c: line 1: syntax error: unexpected end of file BOX_NAME SU 06/21/2013 03:44:03 06/21/2013 07:46:37 0 #My awkfile { ...

6. Shell Programming and Scripting

How to find all files other than first two dates & last date per month and year?

how to find all files other than first two dates & last date per month and year Hi All, lets say there are following files in directory -rwxr-xr-x 1 user userg 1596 Mar 19 2012 a.txt -rwxr-xr-x 1 user userg 1596 Mar 19 2012 b.txt -rwxr-xr-x 1 user userg ...

7. UNIX for Beginners Questions & Answers

How bash treats literal date value and retrieve year, month and date?

Hi, I am trying to add few (say 3 days) to sysdate using - date -d '+ 3 days' +%y%m%d and it works as expected. But how to add few (say 3 days) to a literal date value and how bash treats a literal value as a date. Can we say just like in ORACLE TO_DATE that my given literal date value...

LEARN ABOUT PHP

datetime.setdate

DATETIME.SETDATE(3)							 1						       DATETIME.SETDATE(3)

DateTime::setDate - Sets the date

       Object oriented style

SYNOPSIS

       public DateTime DateTime::setDate (int  $year, int  $month, int	$day)

DESCRIPTION

       Procedural style
       DateTime date_date_set (DateTime  $object, int  $year, int  $month, int	$day)

	Resets the current date of the DateTime object to a different date.

PARAMETERS

	      o $object
		-Procedural style only: A DateTime object returned by date_create(3). The function modifies this object.

	      o $year
		- Year of the date.

	      o $month
		- Month of the date.

	      o $day
		- Day of the date.

RETURN VALUES

	Returns the DateTime object for method chaining or FALSE on failure.

CHANGELOG

       +--------+---------------------------------------------------+
       |Version |						    |
       |	|						    |
       |	|		     Description		    |
       |	|						    |
       +--------+---------------------------------------------------+
       | 5.3.0	|						    |
       |	|						    |
       |	| Changed  the return value on success from NULL to |
       |	| DateTime.					    |
       |	|						    |
       +--------+---------------------------------------------------+
EXAMPLES

       Example #1

	      DateTime.setDate(3) example

	      Object oriented style

	      <?php
	      $date = new DateTime();
	      $date->setDate(2001, 2, 3);
	      echo $date->format('Y-m-d');
	      ?>

	      Procedural style

	      <?php
	      $date = date_create();
	      date_date_set($date, 2001, 2, 3);
	      echo date_format($date, 'Y-m-d');
	      ?>

	      The above examples will output:

	      2001-02-03

       Example #2

	      Values exceeding ranges are added to their parent values

	      <?php
	      $date = new DateTime();

	      $date->setDate(2001, 2, 28);
	      echo $date->format('Y-m-d') . "
";

	      $date->setDate(2001, 2, 29);
	      echo $date->format('Y-m-d') . "
";

	      $date->setDate(2001, 14, 3);
	      echo $date->format('Y-m-d') . "
";
	      ?>

	      The above example will output:

	      2001-02-28
	      2001-03-01
	      2002-02-03

SEE ALSO 
DateTime.setISODate(3), DateTime.setTime(3).
PHP Documentation Group 												       DATETIME.SETDATE(3)