Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Parsing a column of text file - best practices
Top Forums UNIX for Beginners Questions & Answers Parsing a column of text file - best practices Post 302997881 by Don Cragun on Monday 22nd of May 2017 12:29:59 AM
Old 05-22-2017
Hi SIMMS7400,
I will have to assume that you have everything under control and do not desire any further help from me. I have asked three times what shell you're using and have not received an answer. Therefore, I am unable to post a good suggested suited to your environment.

I suggested a simple way to calculate the calendar quarter from the month number (in post #10) and in that same post showed simple ways to calculate the month numbers for the three months in that quarter. Instead of using that code, you used other code that clearly calculates quarters incorrectly. (And, the code you showed us in the 1st update to post #13 still uses that incorrect calculation three out of four times when assigning values to _PQ.)

It is clear from your examples, that your definition of FirstQtrWeek and LastQtrWeek is a date that is not in that quarter with the possible exception of cases where the 1st day of a calendar quarter happens to be a Saturday. Your refusal to clearly define how those two values are calculated (instead of just giving ambiguous examples) makes it impossible to suggest code that might meet your requirements. Given that you say that 12/31/2016 is in Q12017 while your calculations (which are purely based on the month number) clearly compute that anything in December is in Q4; I have great difficulty correlating your stated requirements to your code.

I hope that some of my comments have been helpful. I won't bother you with more questions.
 

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

LEARN ABOUT SUSE

cal

CAL(1)							    BSD General Commands Manual 						    CAL(1)

NAME

     cal -- displays a calendar

SYNOPSIS

     cal [-smjy13] [[[day] month] year]

DESCRIPTION

     Cal displays a simple calendar.  If arguments are not specified, the current month is displayed.  The options are as follows:

     -1      Display single month output.  (This is the default.)

     -3      Display prev/current/next month output.

     -s      Display Sunday as the first day of the week.

     -m      Display Monday as the first day of the week.

     -j      Display Julian dates (days one-based, numbered from January 1).

     -y      Display a calendar for the current year.

     -V      Display version information and exit.

     A single parameter specifies the year (1 - 9999) to be displayed; note the year must be fully specified: ``cal 89'' will not display a calen-
     dar for 1989.  Two parameters denote the month (1 - 12) and year.	Three parameters denote the day (1-31), month and year, and the day will
     be highlighted if the calendar is displayed on a terminal.  If no parameters are specified, the current month's calendar is displayed.

     A year starts on Jan 1. The first day of the week is determined by the locale.

     The Gregorian Reformation is assumed to have occurred in 1752 on the 3rd of September.  By this time, most countries had recognized the ref-
     ormation (although a few did not recognize it until the early 1900's.)  Ten days following that date were eliminated by the reformation, so
     the calendar for that month is a bit unusual.

HISTORY

     A cal command appeared in Version 6 AT&T UNIX.

OTHER VERSIONS

     Several much more elaborate versions of this program exist, with support for colors, holidays, birthdays, reminders and appointments, etc.
     For example, try the cal from http://home.sprynet.com/~cbagwell/projects.html or GNU gcal.

AVAILABILITY

     The cal command is part of the util-linux-ng package and is available from ftp://ftp.kernel.org/pub/linux/utils/util-linux-ng/.

BSD
								   June 6, 1993 							       BSD
All times are GMT -4. The time now is 09:34 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy