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

citserver

citmail(8)						      System Manager's Manual							citmail(8)

NAME

       citserver - Core of the Citadel Suite.

SYNOPSIS

       citserver [-lLogFacility] [-d] [-f] [-D]  [-tTraceFile] [-xLogLevel] [-hHomeDir]

DESCRIPTION

       Citadel	(the  binary  name is citserver) is the core of the Citadel Suite. It provides Data-storage and Connection-oriented protocols like
       IMAP/POP/SMTP. Citserver will usualy be spawned via /etc/init.d or inittab. Unless using the -h option you shouldn't run several  instances
       at once. .SH OPTIONS

       SwitchResult

       -l     Log facility. Usually "mail"

       -d     daemonize (detach from controlling terminal)

       -D     print the directories the server would access to stderr on startup

       -t[TraceFile]
	      Send log messages to a file instead of syslog

       -x[LogLevel]
	      Verbosity level of logging (0 to 9)

       -h[HomeDir]
	      Data  directory  for this Citadel installation. If the directory name begins with a forward slash, it is an absolute path; otherwise
	      it is relative to the default. Watch the output of -D to observe the effects.

DEFAULTS

       Default port bindings opened by citserver:

       PortDescription

       25     SMTP

       110    POP3

       143    IMAP

       465    SMTPS

       504    Citadel protocol

       587    MSA

       993    IMAPS

       995    POP3S

       2020   ManageSieve Unix Domain Sockets opened by citserver:

       Socket namePurpose

       citadel.socket
	      Citadel

       lmtp.socket
	      LMTP

       lmtp-unfiltered.socket
	      LMPT bypassing the Spamassassin facilities

FILES

       /usr/share/citadel-server/
	      Citadels Messages and help files

       /var/lib/citadel/
	      Citadel data files

       /var/run/citadel/
	      volatile files like the Unix Domain Sockets

       /etc/citadel/
	      Citadel configuration files

       /usr/local/citadel/
	      when compiled in non-LHFS mode, all of the above.

       /etc/init.d/citadel/
	      init script for CitServer; add reboot-safe parameters here.

       /etc/default/citadel/
	      Optoins to /etc/init.d/citadel/ in LHFS installations; add commandline options here.

HISTORY

       1987 - Now the Uncensored Communications Group

																	citmail(8)