Splitting week start date and end date based on custom period start dates Post: 303044387

Sponsored Content

Top Forums UNIX for Beginners Questions & Answers Splitting week start date and end date based on custom period start dates Post 303044387 by RudiC on Thursday 20th of February 2020 07:11:58 AM

02-20-2020

Registered User

Given the input is exactly as given in post #1, i.e. no more nor less than three weeks between the two period dates, try (running awk thrice and date twice only, and opening / reading file twice as well)

Code:

awk '
NR > 1 {print $1 ORS $2}
' file |
date -f- +"%s %u" |
awk '
BEGIN   {SECDAY = 86400
         SEC6DY = SECDAY * 6
        }

        {WSD = $1
         WED = WSD + (7 - $2) * SECDAY
         getline
         print "@" WSD
         while (WED < $1)       {print "@" WED
                                 WSD = WED + SECDAY
                                 WED = WSD + SEC6DY
                                 print "@" WSD 
                                }
         print "@" $1
 }' |
date -f- +"%Y-%m-%d" |
awk '
BEGIN           {getline LN < "file"
                 print "week Start Date", "Week End Date", LN
                } 
                
NR%6 == 1       {getline LN < "file"
                } 
                {getline TMP
                 print $0, TMP, LN
                }
' OFS="\t" 
week Start Date Week End Date period_start_date    period_end_date    period_code
2020-01-01    2020-01-05    2020-01-01    2020-01-15    P1
2020-01-06    2020-01-12    2020-01-01    2020-01-15    P1
2020-01-13    2020-01-15    2020-01-01    2020-01-15    P1
2020-01-05    2020-01-05    2020-01-05    2020-01-19    P2
2020-01-06    2020-01-12    2020-01-05    2020-01-19    P2
2020-01-13    2020-01-19    2020-01-05    2020-01-19    P2
2020-01-16    2020-01-19    2020-01-16    2020-01-31    P1
2020-01-20    2020-01-26    2020-01-16    2020-01-31    P1
2020-01-27    2020-01-31    2020-01-16    2020-01-31    P1
.
.
 .

The first awk prints periods' start and end alternately, then date converts that entire input stream to epoch seconds and day of week line by line, then awk produces three weeks' start and end dates totaling in 6 epoch seconds per input line, then date converts those back to the desired date format, and awk merges these with the original input file.

Last edited by RudiC; 02-20-2020 at 08:22 AM..

RudiC

View Public Profile for RudiC

Find all posts by RudiC

7 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Compare Start date and End date...

Hi All, I have problem in my file. It has two date variable. There are 2 variables which has the values as below 1. START_MONTH = �Date(YYYYMM) format� Ex: 201008 2. END_MONTH = �Date(YYYYMM) format� Ex: 201105 The end date should be greater than start date. Now we...

2. Shell Programming and Scripting

Need to capture all dates between start date and End date.

Hi All, I enter Start date and end date as parameters. I need to capture dates between start date and end date. Please let me know if you have any idea the same. Thanks in advance. Nagaraja Akkivalli.

3. Shell Programming and Scripting

Need to capture dates between start date and end date Using perl.

Hi All, Want to get all dates and Julian week number for that date between the start date and end date. How can I achive this using perl? (To achive above functionality, I was connecting to the database from DB server. Need to execute the same script in application server, since databse...

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

Getting the Start, End time and duration using date command

Oracle Enterprise Linux We want to track how long a process takes to complete its execution. This is what we want in the schell script Before the process is started , get the time with date, hours and minutes execute the process After the process has ended , get the time with date,...

6. Shell Programming and Scripting

Get the lines from logfile within start and end date

Hi guys, I am having the below logfile,date in yyyy-mm-dd 2013-08-02 *some content* 2013-08-02 *some content* 2013-08-02 *some content* 2013-08-03 *some content* 2013-08-05 *some content* from the above logfile i need to get the lines between the two timestamps,if i give...

7. UNIX for Dummies Questions & Answers

Print start date to end date, given $1 & $2 in ksh

Dear all, I have an user passing 2 parameter 31/03/2015 and 02/04/2015 to a ksh script. How to print the start date to end date. Expected output is : 31/03/2015 01/04/2015 02/04/2015 Note : 1. Im using aix and ksh 2. I have tried to convert the given input into a date, didnt...

LEARN ABOUT DEBIAN

asql

ASQL(8) 						 Perl Programmers Reference Guide						   ASQL(8)

NAME

       asql - Provide an SQL interface to Apache logfiles.

SYNOPSIS

	 asql [options]

	 General Options:

	  --help       Show brief help intstructions.
	  --manual     Show more complete help.
	  --version    Show the version of the software.

	 Scripting Options:

	  --load       Load the named file, or glob.
	  --execute    Execute a single query then exit.

	 Options:

	  --file       Rather than running as a shell read commands from a named file.
	  --quiet      Don't show the banner at startup.

DESCRIPTION

	 asql provides a simple console interface to allow a user to
	query the contents of an Apache logfile via an SQL interface.

	 The shell features include:

       Persistent alias definitions.
       Command line completion
       Command history
       Simple scriptability

INTRODUCTION

	 The asql shell will create a temporary SQLite database based upon
	any number of Apache logfiles.	This temporary database may then
	be interactively queried using common SQL syntax.

	 To get started you should load your logfiles into the database:

	  load /var/log/apache2/acces*

	 (The tool will automatically decompress files which have been
	compressed with gzip or bzip2.)

	 Once you've loaded at least one file you may run queries, for
	example:

	 SELECT source,SUM(size) AS Number FROM logs GROUP BY source ORDER BY Number DESC, ip

	 This example shows all the clients connecting to your webserver
	and the size of files/requests that they have downloaded in total.

	 As you can see we've selected two columns "source" and "SUM(size)".
	To see which other columns are available you may execute the "show"
	command.

	 Because parsing the Apache logfile(s) specified might be quite
	slow there is the option of dumping the temporary SQLite database
	to a known filename with the 'save' command.  The analog to the
	save command is the 'restore' command, which will read in an
	existing SQLite database and allow future queries to be executed
	against it.

FILES

	When the shell starts up it will read and intepret the initialisation
	file of ~/.asqlrc if it exists.  Any commands present in that file
	will be executed prior to the launch of the interactive session.

	All aliases will be read and written to the file ~/.asql.aliases.

	All interactive history will be written to the file ~/.asql.

AUTHOR

	Steve
	--
	http://www.steve.org.uk/

LICENSE

       Copyright (c) 2007,2008,2009,2010 by Steve Kemp.  All rights reserved.

       This module is free software; you can redistribute it and/or modify it under the same terms as Perl itself.  The LICENSE file contains the
       full text of the license.

AUTHOR

	Steve
	--
	http://www.steve.org.uk/

LICENSE

       Copyright (c) 2007-2020 by Steve Kemp.  All rights reserved.

       This module is free software; you can redistribute it and/or modify it under the same terms as Perl itself.  The LICENSE file contains the
       full text of the license.

perl v5.10.1							    2010-10-04								   ASQL(8)