Best way to increment weeks based on fiscal start year
Hi Folks -
I'm looking for the best way to to increment fiscal weeks - allow me to explain.
At my one client, 10/01/17 was the beginning if year fiscal year 2018.
Each week, I need to manage a unique set of variable that are updated in my application - they are called substitution variables.
I manage them (manually) in a comma delimited format, and then run a ksh over them to extract both columns and spool them to an "*.mxl" file in a specific import format.
For instance:
And then the import format is as such:
Then, the "*.mxl" file is read into the target system using a certain utility called from a shell script, but I digress.
As you can see, there are 13 variables. 1 is the current week (from start of fiscal) and the 12 additional previous week variables.
For instance, current week is the upcoming week, which is the 4th week since start of fiscal, as indicated by wk04.
My question is, is there an easy way to manage this and increment as necessary each week (on Saturday) when this is run?
Thank you!
Last edited by SIMMS7400; 10-22-2017 at 12:24 AM..
Is there any way to find "Number of files" that exists on my solaris parition in the starting of 2009 year ?
I know ctime or mtime will not help and unix wouldnt store creation time.
Only hope i can see ( and i am not sure if that will help ) is that my system is up from last 2 years without... (5 Replies)
Hello,
Using bash script, i need to process the following file:
887,86,,2013-11-06,1,10030,5,2,0,200,,
887,86,,2013-11-05,1,10030,5,2,0,199,,
887,138,,2013-11-06,1,10031,6,2,0,1610612736,,
887,164,,2013-11-06,1,10000,0,2,0,36000,,
and to create a new file such as the below
... (2 Replies)
Hello,
I am running under ubuntu18.04
My question is about awk.
inputfile
0wo010011oasasds sdjhsdjh=, u12812888
8jsjkahsjajnsanakn akjskjskj=, suhuhuhwx
kskkxmsnnxsnjxsnjxsnjjnjjdi=, 22878ssssss
Below code adds consecutive numbers when string = is found
run_code:
awk -F'=' -v OFS='='... (4 Replies)
Hi Ravinder,
Could you (and anyone else who wants to help out) check this PHP code and confirm it does what I expect it to do, which is to color a badge based on the weeks a member is active in the latest sequence? I did a cut-paste-change from my "days in sequence" PHP prototype script and it... (6 Replies)
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..
File content:
... (2 Replies)
Discussion started by: nani2019
2 Replies
LEARN ABOUT DEBIAN
lire::weekcalculator
WeekCalculator(3pm) LogReport's Lire Documentation WeekCalculator(3pm)NAME
Lire::WeekCalculator - handle different weeknumbering schemes
SYNOPSIS
use Lire::WeekCalculator;
my $week_calc = new Lire::WeekCalculator();
my $week_no = $week_calc->week_number( $time );
DESCRIPTION
We support three values for LR_WEEK_NUMBERING: ISO (strftime's %V): week starts on monday; W (week starts on monday) and U (week starts on
sunday). See strftime(1).
CONSTRUCTOR
new( %params )
Creates a new week calculator. The style of week numbering is selected using the "style" parameter. If that parameter is omitted, it
defaults to the style set in 'lr_week_numbering' configuration variable.
style()
Returns the week numbering style used. This will be either "U", "W" or "ISO".
week_number( $time )
Returns the week number of $time according the current week numbering scheme. The week number returned is between 1 and 53.
week_idx( $time )
Returns the week index of $time according to the week numbering scheme. The week index is Lire specific and is used to normalise
computations between different scheme in regards of the first incomplete week of the year. In the ISO case, the week index is always equals
to week_number() - 1, for the other style, the week index of the week 0 will be one less than the last week number of the previous year.
last_week_of_year($year)
Returns the week number of the last week in the year $year.
week_start( $year, $week_no )
Returns the epoch time of the first day of week $week_no in year $year when calculated using current style.
find_year_week1_start_date($year)
Returns the date (epoch) at which the first day of the first week of the year $year starts.
strformat()
Returns a string that can be used as the format specificier in calls to strftime to print the week number of this style.
strfdate()
Emulates POSIX::strftime() but picks up the %V if the system strftime doesn't support it. Should be called whenever you use format strings
that may contain week-of-the-year-codes.
AUTHORS
Joost van Baal <joostvb@logreport.org>,
Francis J. Lacoste <flacoste@logreport.org>,
Wessel Dankers <wsl@logreport.org>
VERSION
$Id: WeekCalculator.pm,v 1.16 2006/07/23 13:16:30 vanbaal Exp $
COPYRIGHT
Copyright (C) 2002 Stichting LogReport Foundation LogReport@LogReport.org
This file is part of Lire.
Lire is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free
Software Foundation; either version 2 of the License, or (at your option) any later version.
This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
You should have received a copy of the GNU General Public License along with this program (see COPYING); if not, check with
http://www.gnu.org/copyleft/gpl.html.
Lire 2.1.1 2006-07-23 WeekCalculator(3pm)