Sponsored Content
Top Forums UNIX for Beginners Questions & Answers Parsing a column of text file - best practices Post 302997876 by Don Cragun on Sunday 21st of May 2017 06:47:32 PM
Old 05-21-2017
Quote:
Originally Posted by SIMMS7400
Hi Don -

Thank you!

Where are you seeing 4months in a quarter for 3?

My if logic is checking what quarter I'm currently in:

Code:
if [ $(($(date +%m)/4+1)) -eq 1 ]
then

Is that what you meant?
Hi SIMMS7400,
No. That code had not been presented in the mail to which I responded. But we can use it for discussion now. Although the code above happens to work because there is no month zero. Let's look at the tests for the other three quarters:
Code:
if [ $(($(date +%m)/4+1)) -eq 1 ]
... # Happens to work for months 01, 02, and 03
elif [ $(($(date +%m)/4+1)) -eq 2 ]
... # Treats months 04, 05, 06, and 07 as 2nd quarter.
elif [ $(($(date +%m)/4+1)) -eq 3 ]
... # With ksh, treats months 08, 09, 10, and 11 as 3rd quarter.
... # With bash, treats months 08 and 09 as syntax errors and treats months
... #   10 and 11 as 3rd quarter.
elif [ $(($(date +%m)/4+1)) -eq 4 ]
... # With ksh, treats month 12 as 4th quarter.
... # With bash, treats 08 and 09 as syntax errors and treats 12 as 4th quarter.

Everything marked in red in the comments above look wrong to me! Do you believe that October and November should be in 3rd quarter instead of the 4th quarter? Do you believe that July should be in the 2nd quarter instead of the 3rd quarter? What shell are you using? If you're using bash, do you believe that August and September should not be in any quarter in a calendar year?

I believe that Q1 should be months January, February, and March; Q2 should be months April, May, and June; Q3 should be months July, August, and September; and Q3 should be months October, November, and December. That is not what your code does!
Quote:
---------- Post updated at 07:59 AM ---------- Previous update was at 07:39 AM ----------

Also, what would be the best way to derive these two values?

Code:
FirstQtrWeek,12/31/16
LastQtrWeek,03/25/17

My week starts on a Saturday.

Thanks!
Define your terms!
Is FirstQtrWeek supposed to be the 1st Saturday before January 2, of the current year?

Is LastQtrWeek supposed to be the 1st Saturday before XX/02/YYYY where XX is the 1st month of the current quarter in calendar year YYYY?

And, I repeat, what shell are you using?
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Text File Parsing

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)
Discussion started by: Djlethal
2 Replies

2. Shell Programming and Scripting

Parsing text from file

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)
Discussion started by: ndnkyd
0 Replies

3. Shell Programming and Scripting

Column wise file parsing.

Shell script for the below operation : File "A" contains : SEQ++1' MOA+9:000,00:ABC' RFF+AIK:000000007' FII+PH+0170++AA' NAD+PL+++XXXXXXXXXXX XXXXXXX XX++XXX XXXX XXXX X.X. XXXXXXXXX+++NL' SEQ++2' MOA+9:389,47:ABC' RFF+AIK:02110300000008' FII+PH+0PSTBNL2A:25:5+BB'... (5 Replies)
Discussion started by: navojit dutta
5 Replies

4. Shell Programming and Scripting

Need help parsing a text file

I have a text file: router1#sh ip blah blah | incl --- Gi2/8 10.60.4.181 --- 10.60.123.175 11 0000 0000 355K Gi2/8 10.60.83.28 --- 224.10.10.26 11 F9FF 3840 154K Gi2/8 10.60.83.198 --- ... (1 Reply)
Discussion started by: streetfighter2
1 Replies

5. UNIX for Dummies Questions & Answers

Replacing a specific column of a text file with another column

I have a text file in the following format: 13412 NA06985 0 0 2 46.6432798439 4 4 4 4 13412 NA06991 NA06993 NA06985 2 48.8478948517 4 4 2 4 13412 NA06993 0 0 1 45.8022601455 4 4 2 4 13401 NA06994 0 0 1 48.780669145 4 4 4 4 13401 NA07000 0 0 2 47.7312017846 2 4 4 4 13402 NA07019... (3 Replies)
Discussion started by: evelibertine
3 Replies

6. UNIX for Dummies Questions & Answers

Replacing a specific column of a text file with another column

Hi, I have a text file in the following format: Code: 13412 NA06985 0 0 2 46.6432798439 4 4 4 4 13412 NA06991 NA06993 NA06985 2 48.8478948517 4 4 2 4 13412 NA06993 0 0 1 45.8022601455 4 4 2 4 13401 NA06994 0 0 1 48.780669145 4 4 4 4 13401 NA07000 0 0 2 47.7312017846 2 4 4 4 ... (2 Replies)
Discussion started by: evelibertine
2 Replies

7. Programming

Parsing a Text file using C++

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)
Discussion started by: agupta2
5 Replies

8. Shell Programming and Scripting

Parsing text file

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)
Discussion started by: comp8765
3 Replies

9. Shell Programming and Scripting

Parsing text file

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)
Discussion started by: jacobs.smith
7 Replies

10. Shell Programming and Scripting

Parsing a fixed column text file in sed

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)
Discussion started by: wvdeijk
4 Replies
All times are GMT -4. The time now is 03:37 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy