Best way to increment weeks based on fiscal start year


 
Thread Tools Search this Thread
Top Forums UNIX for Beginners Questions & Answers Best way to increment weeks based on fiscal start year
# 15  
Old 10-23-2017
Hi Don -

Thank you for taking the time to go over this with me.

I will try this out and get back to you.

---------- Post updated at 06:33 PM ---------- Previous update was at 06:29 PM ----------

Hi Don -

I'm getting the following error:

Code:
((0)T + 1) % 7: syntax error


Last edited by rbatte1; 11-03-2017 at 08:37 AM.. Reason: Added CODE tags
# 16  
Old 10-23-2017
If you have a very recent bash, you might also try that ksh printf command with it. If that doesn't work, you can try perl as discussed in General Purpose Date Script, or you can try parsing the output from the cal utility, or you can write some C code using the mktime(), strftime(), and/or strptime() functions.
# 17  
Old 10-24-2017
Quote:
Originally Posted by RudiC
How do these two statements fit together?



What do you mean?

Hi Rudi -

I'm getting the following error with your code (particularly your 3rd example - which is the correct one for the fiscal year increment going from 53 to 1:

Quote:
FY="${FY//[a-z;\']/}": bad substitution
Once I can correct that, I think i can use that same example to build some dynamic loops. ANy ideas as to what the error is? I tried to correct to no avail.

Thank you!
# 18  
Old 10-29-2017
HI Rudi -

Sorry for the bother - I can't seem to figure out the above error. Do you have any idea?

AIX / kornshell
# 19  
Old 10-29-2017
It works fine with my bash. You have to experiment with your ksh. Double check with your man ksh on "Parameter Expansion". It may not accept the escaped single quote - test with leaving that out, and / or using "'" instead.
This User Gave Thanks to RudiC For This Post:
# 20  
Old 10-30-2017
Thanks, Rudi!

Been playing around with this but unfortunately unable to get it to work.

I'll keep plugging away.
# 21  
Old 10-31-2017
Is it the single quote, be it escaped or not? Or another character? Or doesn't your shell like that special parameter expansion at all? Without further evidence, I'm afraid your external help will become scarce.
This User Gave Thanks to RudiC For This Post:
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

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

2. Web Development

Color a Badge Based on the Weeks the Member is Active in the Latest Sequence

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

3. Shell Programming and Scripting

Increment with awk - how to define start value

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

4. Shell Programming and Scripting

Create new file with increment column based on conditions

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

5. Shell Programming and Scripting

How to calculate the total number of weeks from a specify year?

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

6. Shell Programming and Scripting

Value Increment based on count

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

7. Shell Programming and Scripting

My PM has told me to learn shell scripting in 2 weeks , how should I start?

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

8. Shell Programming and Scripting

how to increment days according to year & month

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

9. Solaris

Number of files - in start of year

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

10. Shell Programming and Scripting

How many weeks in a year

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
Login or Register to Ask a Question