Sponsored Content
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
VFS_SCANNEDONLY(8)					    System Administration tools 					VFS_SCANNEDONLY(8)

NAME
vfs_scannedonly - Ensures that only files that have been scanned for viruses are visible and accessible to the end user. SYNOPSIS
vfs objects = scannedonly DESCRIPTION
This VFS module is part of the samba(8) suite. The vfs_scannedonly VFS module ensures that only files that have been scanned for viruses are visible and accessible to the end user. If non-scanned files are found an anti-virus scanning daemon is notified. The anti-virus scanning daemon is not part of the Samba suite. Scannedonly comes in two parts: a samba vfs module and (one or more) daemons. The daemon scans files. If a certain file is clean, a second file is created with prefix .scanned:. The Samba module simply looks if such a .scanned: file exists, and is newer than the pertinent file. If this is the case, the file is shown to the user. If this is not the case, the file is not returned in a directory listing (configurable), and cannot be opened (configurable). The Samba vfs module will notify the daemon to scan this file. So what happens for the user in the default configuration. The first time a directory is listed, it shows files as 'file is being scanned for viruses, but after the first time all files are shown. There is a utility scannedonly_prescan that can help you to prescan all directories. When new files are written the daemon is notified immediately after the file is complete. If a virus is found by the daemon, a file with a warning message is created in the directory of the user, a warning is sent to the logs, and the file is renamed to have prefix .virus:. Files with the .virus: prefix are never shown to the user and all access is denied. This module is stackable. CONFIGURATION
vfs_scannedonly relies on a anti-virus scanning daemon that listens on the scannedonly socket (unix domain socket or UDP socket). OPTIONS
scannedonly:domain_socket = True Whether to use a unix domain socket or not (false reverts to use udp) scannedonly:socketname = /var/lib/scannedonly/scan The location of the unix domain socket to connect to scannedonly:portnum = 2020 The udp port number to connect to scannedonly:scanhost = localhost When using UDP the host that runs the scanning daemon (this host needs access to the files!) scannedonly:show_special_files = True Whether sockets, devices and fifo's (all not scanned for viruses) should be visible to the user scannedonly:rm_hidden_files_on_rmdir = True Whether files that are not visible (.scanned: files, .failed: files and .virus: files) should be deleted if the user tries to remove the directory. If false, the user will get the "directory is not empty" error. scannedonly:hide_nonscanned_files = True If false, all non-scanned files are visible in directory listings. If such files are found in a directory listing the scanning daemon is notified that scanning is required. Access to non-scanned files is still denied (see scannedonly:allow_nonscanned_files). scannedonly:scanning_message = is being scanned for viruses If non-scanned files are hidden (if scannedonly:hide_nonscanned_files = True), a fake 0 byte file is shown. The filename is the original filename with the message as suffix. scannedonly:recheck_time_open = 50 If a non-scanned file is opened, the vfs module will wait recheck_tries_open times for recheck_time_open milliseconds for the scanning daemon to create a .scanned: file. For small files that are scanned by the daemon within the time (tries * time) the behavior will be just like on-access scanning. scannedonly:recheck_tries_open = 100 See recheck_time_open. scannedonly:recheck_time_readdir = 50 If a non-scanned file is in a directory listing the vfs module notifies the daemon (once for all files that need scanning in that directory), and waits recheck_tries_readdir times for recheck_time_readdir milliseconds. Only used when hide_nonscanned_files is false. scannedonly:recheck_tries_readdir = 20 See recheck_time_readdir. scannedonly:allow_nonscanned_files = False Allow access to non-scanned files. The daemon is notified, however, and special files such as .scanned: files. .virus: files and .failed: files are not listed. EXAMPLES
Enable anti-virus scanning: [homes] vfs objects = scannedonly scannedonly:hide_nonscanned_files = False CAVEATS
This is not true on-access scanning. However, it is very fast for files that have been scanned already. VERSION
This man page is correct for version 4.0.0 of the Samba suite. AUTHOR
The original Samba software and related utilities were created by Andrew Tridgell. Scannedonly was developed for Samba by Olivier Sessink. Samba is now developed by the Samba Team as an Open Source project similar to the way the Linux kernel is developed. Samba 4.0 06/17/2014 VFS_SCANNEDONLY(8)
All times are GMT -4. The time now is 02:47 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy