10-23-2017
Hi SIMMS7400,
In post #51 in your earlier thread (
Parsing a column of text file - best practices) I gave you code that contains a function (
findSaturdayOnOrBefore()) that finds the 1st Saturday on or before a date given to it as an argument. Since it worked for me when I was testing it and you never said that it didn't work for you, I assumed that it worked for you (although you haven't acknowledged seeing that post).
Can't you use that function to determine the 1st Saturday on or before
10/07/YYYY? Isn't the result returned by that function the first day of a fiscal year for your customer? Can't you then find the first day of the next fiscal year using that function with
10/07/$((YYYY+1)) as the argument. And then, can't you add one week to the first day in a fiscal year in a loop until you hit the 1st week of the next fiscal year saving the 52 or 53 values you get in that loop as the start of the 52 or 53 weeks in that fiscal year?
Why don't you try doing this on your own, show us what you come up with, and let us know if you get stuck?
PS: Is 10/07/2017 the first day of your customer's FY2017 or is it the first day of FY2018?
PPS: Note that we are here to help you learn how to use the tools on your UNIX or UNIX-like system to write code that makes it do what you want it to do. We are not here to act as your unpaid programming staff.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I search how i could do to find if a year (for example 2004, 1989, 2058) has 52 or 53 weeks...
Have you a idea for me please??? (1 Reply)
Discussion started by: Castelior
1 Replies
2. Solaris
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)
Discussion started by: rajwinder
5 Replies
3. Shell Programming and Scripting
Hiii i have a file with data as shown below:
a.dat:
RAO 1900 2 7 0 0 0.00 10.8000 76.8000 10.0 0 0.00 0 6.00 0.00 0.00 0 0.00 6.00 0 NULL
LEE 1901 2 15 0 0 0.00 26.0000 100.0000 0.0 0 0.00 0 0.00 0.00 0.00 0 6.00 6.00 0 NULL
RAO 1901 4... (3 Replies)
Discussion started by: reva
3 Replies
4. Shell Programming and Scripting
My PM has told me to learn shell scrting in 2 weeks , how should I start?:confused::confused::confused::confused: (1 Reply)
Discussion started by: manalisharmabe
1 Replies
5. Shell Programming and Scripting
Hi All,
I have source file
x.txt
0001|0003
0031|0031
0045|0049
My desired output should be:
y.txt
0001
0002
0003
0031
0045
0046
0047 (11 Replies)
Discussion started by: kmsekhar
11 Replies
6. Shell Programming and Scripting
Hi anyone can help?
How to calculate total number of weeks from a specify date, for example, 01 Jan 2012.
Thx! (2 Replies)
Discussion started by: rayray2013
2 Replies
7. Shell Programming and Scripting
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)
Discussion started by: JonhyDeep
2 Replies
8. Shell Programming and Scripting
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)
Discussion started by: baris35
4 Replies
9. Web Development
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)
Discussion started by: Neo
6 Replies
10. UNIX for Beginners Questions & Answers
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
html::calendarmonth::datetool
HTML::CalendarMonth::DateTool(3pm) User Contributed Perl Documentation HTML::CalendarMonth::DateTool(3pm)
NAME
HTML::CalendarMonth::DateTool - Base class for determining which date package to use for calendrical calculations.
SYNOPSIS
my $date_tool = HTML::CalendarMonth::DateTool->new(
year => $YYYY_year,
month => $one_thru_12_month,
weeknum => $weeknum_mode,
historic => $historic_mode,
datetool => $specific_datetool_if_desired,
);
DESCRIPTION
This module attempts to utilize the best date calculation package available on the current system. For most contemporary dates this usually
ends up being the internal Time::Local package of perl. For more exotic dates, or when week number of the years are desired, other methods
are attempted including DateTime, Date::Calc, Date::Manip, and the linux/unix 'ncal' or 'cal' commands. Each of these has a specific
subclass of this module offering the same utility methods needed by HTML::CalendarMonth.
METHODS
new()
Constructor. Takes the following parameters:
year
Year of calendar in question (required). If you are rendering exotic dates (i.e. dates outside of 1970 to 2038) then something
besides Time::Local will be used for calendrical calculations.
month
Month of calendar in question (required). 1 through 12.
weeknum
Optional. When specified, will limit class excursions to those that are currently set up for week of year calculations.
historic
Optional. If the the ncal or cal commands are available, use one of them rather than other available date modules since these
utilities accurately handle some specific historical artifacts such as the transition from Julian to Gregorian.
datetool
Optional. Mostly for debugging, this option can be used to indicate a specific HTML::CalendarMonth::DateTool subclass for
instantiation. The value can be either the actual utility class, e.g., Date::Calc, or the name of the CalendarMonth handler leaf
class, e.g. DateCalc. Use 'ncal' or 'cal', respectively, for the wrappers around those commands.
There are number of methods automatically available:
month()
year()
weeknum()
historical()
datetool()
Accessors for the parameters provided to "new()" above.
dow1st()
Returns the day of week number for the 1st of the "year" and "month" specified during the call to "new()". Relies on the presence of
"dow1st_and_lastday()". Should be 0..6 starting with Sun.
lastday()
Returns the last day of the month for the "year" and "month" specified during the call to "new()". Relies on the presence of
"dow1st_and_lastday()".
Overridden methods
Subclasses of this module must provide at least the "day_epoch()" and "dow1st_and_lastday()" methods.
dow1st_and_lastday()
Required. Provides a list containing the day of the week of the first day of the month (0..6 starting with Sun) along with the last day
of the month.
day_epoch()
Optional unless interested in epoch values for wacky dates. For a given day, and optionally "month" and "year" if they are different
from those specified in "new()", provide the unix epoch in seconds for that day at midnight.
If the subclass is expected to provide week of year numbers, three more methods are necessary:
dow()
For a given day, and optionally "month" and "year" if they are different from those specified in "new()", provide the day of week
number. (1=Sunday, 7=Saturday).
add_days($days, $delta, $day, [$month], [$year])
For a given day, and optionally "month" and "year" if they are different from those specified in "new()", provide a list of year,
month, and day once "delta" days have been added.
week_of_year($day, [$month], [$year])
For a given day, and optionally "month" and "year" if they are different from those specified in "new()", provide a list with the week
number of the year along with the year. (some days of a particular year can end up belonging to the prior or following years).
AUTHOR
Matthew P. Sisk, <sisk@mojotoad.com>
COPYRIGHT
Copyright (c) 2010 Matthew P. Sisk. All rights reserved. All wrongs revenged. This program is free software; you can redistribute it and/or
modify it under the same terms as Perl itself.
SEE ALSO
HTML::CalendarMonth(3), Time::Local(3), DateTime(3), Date::Calc(3), Date::Manip(3), cal(1)
perl v5.12.4 2011-08-26 HTML::CalendarMonth::DateTool(3pm)