Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Splitting week start date and end date based on custom period start dates
Top Forums UNIX for Beginners Questions & Answers Splitting week start date and end date based on custom period start dates Post 303043750 by nani2019 on Wednesday 5th of February 2020 11:04:48 AM
Old 02-05-2020
Splitting week start date and end date based on custom period start dates
Below are my custom period start and end dates based on a calender, these dates are placed in a file, for each period i need to split into three weeks for each period row, example is given below.

Could you please help out to achieve solution through shell script..

Code:
 File content:

period_start_date	period_end_date	period_code
2020-01-01	2020-01-15	P1
2020-01-05	2020-01-19	P2
2020-01-16	2020-01-31	P1
2020-01-20	2020-02-04	P2
2020-02-01	2020-02-15	P1
2020-02-05	2020-02-19	P2
2020-02-16	2020-02-29	P1
2020-02-20	2020-03-04	P2
2020-03-01	2020-03-15	P1
2020-03-05	2020-03-19	P2
2020-03-16	2020-03-31	P1
2020-03-20	2020-04-04	P2
2020-04-01	2020-04-15	P1
2020-04-05	2020-04-19	P2
2020-04-16	2020-04-30	P1
2020-04-20	2020-05-04	P2
2020-05-01	2020-05-15	P1
2020-05-05	2020-05-19	P2
2020-05-16	2020-05-31	P1
2020-05-20	2020-06-04	P2

Code:
Expected Result for  					
1) period start date 	2020-01-01	Period End date	2020-01-15	Period code 	 P1        
2) period start date 	2020-01-05	Period End date	2020-01-19	Period code 	 P2     
3) period start date 	2020-01-16	Period End date	2020-01-31	Period code 	 P1     
4) period start date 	2020-01-20	Period End date	2020-02-04	Period code 	 P2

Code:
week Start Date	Week End Date	Period strat 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
2020-01-20	2020-01-26	2020-01-20	2020-02-04	P2
2020-01-27	2020-02-02	2020-01-20	2020-02-04	P2
2020-02-03	2020-02-04	2020-01-20	2020-02-04	P2

Last edited by nani2019; 02-05-2020 at 12:05 PM.. Reason: none
 

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... (3 Replies)
Discussion started by: suresh01_apk
3 Replies

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. (5 Replies)
Discussion started by: Nagaraja Akkiva
5 Replies

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... (6 Replies)
Discussion started by: Nagaraja Akkiva
6 Replies

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... (2 Replies)
Discussion started by: parthmittal2007
2 Replies

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,... (5 Replies)
Discussion started by: omega3
5 Replies

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... (5 Replies)
Discussion started by: mohanalakshmi
5 Replies

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... (0 Replies)
Discussion started by: mr.rajaravi
0 Replies

LEARN ABOUT DEBIAN

grid-cert-info

GRID-CERT-INFO(1)						  Globus Commands						 GRID-CERT-INFO(1)

NAME

       grid-cert-info - Display information about a certificate

SYNOPSIS

       grid-cert-info [-help] [-usage] [-version] [-versions]

       grid-cert-info [-file CERTIFICATE-FILE] [-rfc2253] [-all]
		      [-subject] | [-s]
		      [-issuer] | [-i]
		      [-issuerhash] | [-ih]
		      [-startdate] | [-sd]
		      [-endate] | [-ed]

DESCRIPTION

       The grid-cert-info program displays information contained within a certificate file. By default it shows a text representation of the
       entire certificate. Specific facts about the certificate can be shown instead by using command-line options. If any of those options are
       used, then the default display is suppressed. This can be added to the output by using the -all command-line option.

       If multiple display options are included on the command-line, the facts related to those will be displayed on separate lines in the order
       that they occur. If an option is specified multiple time, that fact will be displayed multiple times.

       The full set of command-line options to grid-cert-info are:

       -help, -usage
	   Display the command-line options to grid-cert-info and exit.

       -version, -versions
	   Display the version number of the grid-cert-info command. The second form includes more details.

       -file CERTIFICATE-FILE
	   Display information about the first certificate contained in the file named by CERTIFICATE-FILE instead of the default user
	   certificate.

       -rfc2253
	   Display X.509 distinguished names using the string representation defined in RFC 2253 instead of the default OpenSSL oneline format.

       -all
	   Display the text representation of the entire certificate in addition to any other facts requested by command-line options. This is the
	   default if no fact-specific command-line options are used.

       -subject, -s
	   Display the subject name of the X.509 certificate.

       -issuer, -i
	   Display the issuer name of the X.509 certificate.

       -issuerhash, -ih
	   Display the default hash of the issuer name of the X.509 certificate. This can be used to locate which CA certificate in the trusted
	   certificate directory issued the certifcate being inspected.

       -startdate, -sd
	   Display a string representation of the date and time when the certificate is valid from. This is displayed in the format used by the
	   OpenSSL x509 command.

       -enddate, -dd
	   Display a string representation of the date and time when the certificate is valid until. This is displayed in the format used by the
	   OpenSSL x509 command.

EXAMPLES

       Display the validity times for the default certificate

	   % grid-cert-info -sd -ed
	   Aug 31 12:33:47 2009 GMT
	   Aug 31 12:33:47 2010 GMT

       Display the same information about a different certificate specified on the command-line

	   % grid-cert-info -sd -ed -f /etc/grid-security/hostcert.pem
	   Jan 21 12:24:48 2003 GMT
	   Jul 15 11:30:57 2020 GMT

       Display the subject of a certificate in both the default and the RFC 2253 forms.

	   % grid-cert-info -subject
	   /DC=org/DC=example/DC=grid/CN=Joe User
	   % grid-cert-info -subject -rfc2253
	   CN=Joe User,DC=grid,DC=example,DC=org

ENVIRONMENT VARIABLES

       The following environment variables affect the execution of grid-cert-info:

       X509_USER_CERT
	   Path to the default certificate file to inspect.

AUTHOR

       University of Chicago

Globus Toolkit 5.0.1						    03/22/2010							 GRID-CERT-INFO(1)
All times are GMT -4. The time now is 11:09 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy