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 302998345 by Don Cragun on Tuesday 30th of May 2017 04:13:11 PM
Old 05-30-2017
Quote:
Originally Posted by SIMMS7400
Hi Don -

... ... ...

And yes, you are right, if run during those special occasions, my code would be wrong for quite a few variables. My next task was going to be trying to solve for that.

1. ALLC_CurrentWeek - Day in which script is ran

2.ALLC_CurrentPeriod - Assumes the same behavior of what we spoke about before, your posy #18.

3.PriorQuarterAD - Same concept as post #18.
4.CurrentQtrInput -Same concept as post #18
5.PriorQtrInput - Same concept as post #18.



For instance, if day (Saturday which is the day the script is ran) is 12/31, ALLC_CurrentWeek would be 12/31/16, ALLC_CurrentPeriod would be Jan, and PriorQuarter would be De, CurrentQtrInput would be Jan, and PriorQtrInput would be Dec.


Thank you, Don!
You're giving examples again; not definitions. And the strings associated with these values do not correlate with the values you seem to want following them.

You seem to be saying that ALLC_CurrentWeek is a synonym for CurrentWeek. Why have two names for the same thing? If they aren't the same, what is the difference between them?

Note that I say the names don't correlate to the strings because a day (12/31/16) is not a week (12/31/16-01/06/17), but the string you put before the output specifying the Saturday at the start of the week in which you invoke this program is named CurrentWeek (and maybe also ALLC_CurrentWeek). Sometimes you call a month a Period and sometimes you call a month a Mnth and in your examples above you seem to be calling a month a Qtr. Naming something PriorQtrInput and assigning it a value that is an abbreviated month name provides me with no mnemonic relationship.

Please define the above terms in English; not just with examples from which you hope I'll be able to guess at a definition.
 

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 OPENSOLARIS

langinfo

langinfo.h(3HEAD)						      Headers							 langinfo.h(3HEAD)

NAME

       langinfo.h, langinfo - language information constants

SYNOPSIS

       #include <langinfo.h>

DESCRIPTION

       The  <langinfo.h>  header  contains  the constants used to identify items of langinfo data (see nl_langinfo(3C)). The type of the constant,
       nl_item, is defined as described in <nl_types.h>.

       The following constants are defined. The entries under Category indicate in which setlocale(3C) category each item is defined.

		       |		|
	  Constant     |   Category	|		 Meaning
       ----------------+----------------+----------------------------------------
       CODESET	       |LC_CTYPE	|codeset name
       ----------------+----------------+----------------------------------------
       D_T_FMT	       |LC_TIME 	|string for formatting date and time
       ----------------+----------------+----------------------------------------
       D_FMT	       |LC_TIME 	|date format string
       ----------------+----------------+----------------------------------------
       T_FMT	       |LC_TIME 	|time format string
       ----------------+----------------+----------------------------------------
       T_FMT_AMPM      |LC_TIME 	|a.m. or p.m. time format string
       ----------------+----------------+----------------------------------------
       AM_STR	       |LC_TIME 	|ante-meridiem affix
       ----------------+----------------+----------------------------------------
       PM_STR	       |LC_TIME 	|post-meridiem affix
       ----------------+----------------+----------------------------------------
       DAY_1	       |LC_TIME 	|name of the first day of the week  (for
		       |		|example, Sunday)
       ----------------+----------------+----------------------------------------
       DAY_2	       |LC_TIME 	|name of the second day of the week (for
		       |		|example, Monday)
       ----------------+----------------+----------------------------------------
       DAY_3	       |LC_TIME 	|name of the third day of the week  (for
		       |		|example, Tuesday)
       ----------------+----------------+----------------------------------------
       DAY_4	       |LC_TIME 	|name of the fourth day of the week (for
		       |		|example, Wednesday)
       ----------------+----------------+----------------------------------------
       DAY_5	       |LC_TIME 	|name of the fifth day of the week  (for
		       |		|example, Thursday)
       ----------------+----------------+----------------------------------------
       DAY_6	       |LC_TIME 	|name  of the sixth day of the week (for
		       |		|example, Friday)
       ----------------+----------------+----------------------------------------
       DAY_7	       |LC_TIME 	|name of the seventh  day  of  the  week
		       |		|(for example, Saturday)
       ----------------+----------------+----------------------------------------
       ABDAY_1	       |LC_TIME 	|abbreviated  name  of	the first day of
		       |		|the week
       ----------------+----------------+----------------------------------------
       ABDAY_2	       |LC_TIME 	|abbreviated name of the second  day  of
		       |		|the week
       ----------------+----------------+----------------------------------------

       ABDAY_3	       |LC_TIME 	|abbreviated  name  of	the third day of
		       |		|the week
       ----------------+----------------+----------------------------------------
       ABDAY_4	       |LC_TIME 	|abbreviated name of the fourth  day  of
		       |		|the week
       ----------------+----------------+----------------------------------------
       ABDAY_5	       |LC_TIME 	|abbreviated  name  of	the fifth day of
		       |		|the week
       ----------------+----------------+----------------------------------------
       ABDAY_6	       |LC_TIME 	|abbreviated name of the seventh day  of
		       |		|the week
       ----------------+----------------+----------------------------------------
       ABDAY_7	       |LC_TIME 	|abbreviated  name of the seventh day of
		       |		|the week
       ----------------+----------------+----------------------------------------
       MON_1	       |LC_TIME 	|name of the first month of the year
       ----------------+----------------+----------------------------------------
       MON_2	       |LC_TIME 	|name of the second month
       ----------------+----------------+----------------------------------------
       MON_3	       |LC_TIME 	|name of the third month
       ----------------+----------------+----------------------------------------
       MON_4	       |LC_TIME 	|name of the fourth month
       ----------------+----------------+----------------------------------------
       MON_5	       |LC_TIME 	|name of the fifth month
       ----------------+----------------+----------------------------------------
       MON_6	       |LC_TIME 	|name of the sixth month
       ----------------+----------------+----------------------------------------
       MON_7	       |LC_TIME 	|name of the seventh month
       ----------------+----------------+----------------------------------------
       MON_8	       |LC_TIME 	|name of the eighth month
       ----------------+----------------+----------------------------------------
       MON_9	       |LC_TIME 	|name of the ninth month
       ----------------+----------------+----------------------------------------
       MON_10	       |LC_TIME 	|name of the tenth month
       ----------------+----------------+----------------------------------------
       MON_11	       |LC_TIME 	|name of the eleventh month
       ----------------+----------------+----------------------------------------
       MON_12	       |LC_TIME 	|name of the twelfth month
       ----------------+----------------+----------------------------------------
       ABMON_1	       |LC_TIME 	|abbreviated name of the first month
       ----------------+----------------+----------------------------------------
       ABMON_2	       |LC_TIME 	|abbreviated name of the second month
       ----------------+----------------+----------------------------------------
       ABMON_3	       |LC_TIME 	|abbreviated name of the third month
       ----------------+----------------+----------------------------------------
       ABMON_4	       |LC_TIME 	|abbreviated name of the fourth month
       ----------------+----------------+----------------------------------------
       ABMON_5	       |LC_TIME 	|abbreviated name of the fifth month
       ----------------+----------------+----------------------------------------
       ABMON_6	       |LC_TIME 	|abbreviated name of the sixth month
       ----------------+----------------+----------------------------------------
       ABMON_7	       |LC_TIME 	|abbreviated name of the seventh month
       ----------------+----------------+----------------------------------------
       ABMON_8	       |LC_TIME 	|abbreviated name of the eighth month
       ----------------+----------------+----------------------------------------
       ABMON_9	       |LC_TIME 	|abbreviated name of the ninth month
       ----------------+----------------+----------------------------------------
       ABMON_10        |LC_TIME 	|abbreviated name of the tenth month
       ----------------+----------------+----------------------------------------
       ABMON_11        |LC_TIME 	|abbreviated name of the eleventh month
       ----------------+----------------+----------------------------------------
       ABMON_12        | LC_TIME	|abbreviated name of the twelfth month
       ----------------+----------------+----------------------------------------
       ERA	       |LC_TIME 	|era description segments
       ----------------+----------------+----------------------------------------

       ERA_D_FMT       |LC_TIME 	|era date format string
       ----------------+----------------+----------------------------------------
       ERA_D_T_FMT     |LC_TIME 	|era date and time format string
       ----------------+----------------+----------------------------------------
       ERA_T_FMT       |LC_TIME 	|era time format string
       ----------------+----------------+----------------------------------------
       ALT_DIGITS      |LC_TIME 	|alternative symbols for digits
       ----------------+----------------+----------------------------------------
       RADIXCHAR       |LC_NUMERIC	|radix character
       ----------------+----------------+----------------------------------------
       THOUSEP	       |LC_NUMERIC	|separator for thousands
       ----------------+----------------+----------------------------------------
       YESEXPR	       |LC_MESSAGES	|affirmative response expression
       ----------------+----------------+----------------------------------------
       NOEXPR	       |LC_MESSAGES	|negative response expression
       ----------------+----------------+----------------------------------------
       YESSTR	       |LC_MESSAGES	|affirmative response for yes/no queries
       ----------------+----------------+----------------------------------------
       NOSTR	       |LC_MESSAGES	|negative response ro yes/no queries
       ----------------+----------------+----------------------------------------
       CRNCYSTR        |LC_MONETARY	|local currency symbol, preceded by  '-'
		       |		|if  the  symbol sould appear before the
		       |		|value, '+' if the symbol should  appear
		       |		|after	the  value, or '.' if the symbol
		       |		|should replace the radix character

       If the locale's values for p_cs_precedes and n_cs_precedes do not match, the value of nl_langinfo(CRNCYSTR) is unspecified.

       The <langinfo.h> header declares the following as a function:

	 char *nl_langinfo(nl_item);

       Inclusion of <langinfo.h> header may also make visible all symbols from <nl_types.h>.

USAGE

       Wherever possible, users are advised to use functions compatible with those in the ISO C standard to access items of langinfo data. In par-
       ticular, the strftime(3C) function should be used to access date and time information defined in category LC_TIME. The localeconv(3C) func-
       tion should be used to access information corresponding to RADIXCHAR, THOUSEP, and CRNCYSTR.

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Interface Stability	     |Standard			   |
       +-----------------------------+-----------------------------+

SEE ALSO

       mkmsgs(1), localeconv(3C), nl_langinfo(3C), nl_types.h(3HEAD), setlocale(3C), strftime(3C), attributes(5), standards(5)

SunOS 5.11							    30 Aug 2002 						 langinfo.h(3HEAD)
All times are GMT -4. The time now is 01:51 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy