I hope all is well! I have a business process where I manage a text file of substitution variables and their values for a target system. After updating, I run a script to push the changes to the target system.
However, I'm trying to develop a method to be able to automatically advance values without manual intervention. Obviously there may be some exceptions I need to handle in an automated fashion which is fine.
So, the advancement I need to do is week, month and year, based on what subvar it is...
Here is a portion of a sample file :
So, i'm trying to understand the best way to advance. The process runs EVERY Saturday, so as you know, the subvars pertaining to the day/week (xx/xx/xx) will always roll forward, but month and year wont until a new month or new year changes...
So this Saturday, CurrentWeek would roll forward to 2/11/17..All others would remain the same.
However on march forth, all week and MONTH subvars will advance. Years wont advance until we advance for Jan 2018.
My apologies, this is a new requirement for me and the data provided was outdated. Therefore, CurrentWeek actually means current week.
Since these are rolled forward every Saturday, CurrentWeek is 5/20/17.
As it looks, I'm going to try Scrutinzer's solution, but please suggest another option if there is a better way.
Thank you!
It's not just outdated, it's also inconsistent:
If the current week is in February 2017 and the previous period (where period is presumably a month) is January 2017, how is the period 2 months prior 10 months later (December 2017) instead of 2 months earlier (December 2016)?
Is this a homework assignment?
Last edited by Don Cragun; 05-20-2017 at 05:23 PM..
I'm sorry for passing along bad requirements. Our firm is now responsible for some work admins used to do at this particular client therefore I am going through and establishing automation on many pieces of intraday business processes as most of it is manual - and this is one of the tasks.
Here is the correct data set :
I guesss my concern is when CurrentPeriod hits Jan and then Feb and how to return prior year to return 1PeriodPrior or 2PeriodPrior.
I have a text file with records of the form:
A X1 Y1 X2 Y2 X3 Y3
where A is character length 10, Xi is character length 4 and Yi is numeric length 10.
I want to parse the line, and output records like:
A X1 Y1
A X2 Y2
A X3 Y3
etc
Can anyone please give me an idea of how to do this. ... (4 Replies)
Hi Friends,
I am back for the second round today - :D
My input text file is this way
Home
friends
friendship meter
Tools
Mirrors
Downloads
My Data
About Us
Help
My own results
BLAT Search Results
ACTIONS QUERY SCORE START END QSIZE IDENTITY CHRO STRAND ... (7 Replies)
I'm totally stumped with how to handle this huge text file I'm trying to deal with. I really need some help!
Here is what is looks like:
ab1ba67c331a3d731396322fad8dd71a3b627f89359827697645c806091c40b9
0.2
812a3c3684310045f1cb3157bf5eebc4379804e98c82b56f3944564e7bf5dab5
0.6
0.6... (3 Replies)
I was trying to parse the text file, which will looks like this
###XYZABC####
############
int = 4
char = 1
float = 1
.
.
############
like this my text file will contains lots of entries and I need to store these entries in the map eg. map.first = int and map.second = 4 same way I... (5 Replies)
Any ideas?
1)loop through text file
2)extract everything between SOL and EOL
3)output files, for example: 123.txt and 124.txt for the file below
So far I have: sed -n "/SOL/,/EOL/{p;/EOL/q;}" file
Here is an example of my text file.
SOL-123.go
something goes here
something goes... (0 Replies)
Hey Guys.I am a newbie on Bash Shell Scripting and Perl.And I have a question about file parsing.
I have a log file which contains reports about a communication device.I need to take some of the reports from the log file.Its hard to explain the issue.but shortly I can say that, the reports has a... (2 Replies)