awk for column selection Post: 302437878

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk selection on fields

I want to have a search using the month and year to output numerical data. The knowledge i have so far on the matter is: $awk '{print $1, $2, $3, $4 }' hits the result of this is: 123.45.6.7 NOV 2006 1805GMT now for me this code will print out the two colums i want but i need to...

2. Shell Programming and Scripting

for each different entry in column 1 extract maximum values from column 2 in unix/awk

Hello, I have 2 columns (1st column has multiple entries but the corresponding values in the column 2 may be the same or different.) however I want to extract unique values for each entry in column 1 by assigning the max value from column 2 SDF4 -0.211654 SDF4 0.978068 ...

3. Shell Programming and Scripting

Sed or awk : pattern selection based on special characters

Hello All, I am here again scratching my head on pattern selection with special characters. I have a large file having around 200 entries and i have to select a single line based on a pattern. I am able to do that: Code: cat mytest.txt | awk -F: '/myregex/ { print $2}' ...

4. Shell Programming and Scripting

AWK script to create max value of 3rd column, grouping by first column

Hi, I need an awk script (or whatever shell-construct) that would take data like below and get the max value of 3 column, when grouping by the 1st column. clientname,day-of-month,max-users ----------------------------------- client1,20120610,5 client2,20120610,2 client3,20120610,7...

5. Shell Programming and Scripting

awk or sed: change the color of a column w/o screwing up column spacing

Hey folks. I wrote a little awk script that summarizes /proc/net/dev info and then pipes it to the nix column command to set up column spacing appropriately. Here's some example output: Iface RxMBytes RxPackets RxErrs RxDrop TxMBytes TxPackets TxErrs TxDrop bond0 9 83830...

6. Shell Programming and Scripting

awk Print New Column For Every Two Lines and Match On Multiple Column Values to print another column

Hi, My input files is like this axis1 0 1 10 axis2 0 1 5 axis1 1 2 -4 axis2 2 3 -3 axis1 3 4 5 axis2 3 4 -1 axis1 4 5 -6 axis2 4 5 1 Now, these are my following tasks 1. Print a first column for every two rows that has the same value followed by a string. 2. Match on the...

7. Shell Programming and Scripting

awk to sum a column based on duplicate strings in another column and show split totals

Hi, I have a similar input format- A_1 2 B_0 4 A_1 1 B_2 5 A_4 1 and looking to print in this output format with headers. can you suggest in awk?awk because i am doing some pattern matching from parent file to print column 1 of my input using awk already.Thanks! letter number_of_letters...

8. Shell Programming and Scripting

Problems with awk (fatal error) and paste (two variables into one column-by-column)

Hello, I have a script extracting columns of useful numbers from a data file, and manipulating the numbers with awk commands. I have problems with my script... 1. There are two lines assigning numbers to $BaseForAveraging. If I use the commented line (the first one) and let the second one...

9. Shell Programming and Scripting

awk to Sum columns when other column has duplicates and append one column value to another with Care

Hi Experts, Please bear with me, i need help I am learning AWk and stuck up in one issue. First point : I want to sum up column value for column 7, 9, 11,13 and column15 if rows in column 5 are duplicates.No action to be taken for rows where value in column 5 is unique. Second point : For...

10. Shell Programming and Scripting

awk script to append suffix to column when column has duplicated values

Please help me to get required output for both scenario 1 and scenario 2 and need separate code for both scenario 1 and scenario 2 Scenario 1 i need to do below changes only when column1 is CR and column3 has duplicates rows/values. This inputfile can contain 100 of this duplicated rows of...

LEARN ABOUT OPENSOLARIS

shcomp

shcomp(1)							   User Commands							 shcomp(1)

NAME

       shcomp - compile a ksh93 shell script

SYNOPSIS

       shcomp [-nv] [infile [outfile]]

       shcomp -D [infile [outfile]]

DESCRIPTION

       If  the	-D  option  is not specified, shcomp takes a shell script, infile, and creates a binary format file, outfile, that ksh93 reads and
       executes with the same effect as the original script.

       Aliases are processed as the script is read. Alias definitions whose value requires variable expansion will not work correctly.

OPTIONS

       The following options are supported:

       -D	       Generate a list of strings that need to be placed in a message catalog for internationalization.
       --dictionary
		       With this option, all double quoted strings that are preceded by $ are printed, one literal  per  line.	A  literal  $"foo"
		       prints  "foo" in the output. These are the messages that need to be translated to locale specific versions for internation-
		       alization.

       -n	       Display warning messages for obsolete or non-conforming constructs.
       --noexec

       -v	       Display input from infile onto standard error as it reads it.
       --verbose

OPERANDS

       The following operands are supported:

       infile	  Specifies the name of the file that contains the shell script to be used as input.

		  If infile is omitted, the shell script is read from standard input.

       outfile	  Specifies the name of the output file.

		  If outfile is omitted, both modes write their results to standard output.

EXIT STATUS

       The following exit values are returned:

       0     Successful completion.

       >0    An error occurred.

ATTRIBUTES

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

       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Availability		     |SUNWcsu			   |
       +-----------------------------+-----------------------------+
       |CSI			     |Enabled			   |
       +-----------------------------+-----------------------------+
       |Interface Stability	     |See below.		   |
       +-----------------------------+-----------------------------+

       The command-line interface and the system variables are Committed. The compiled shell code format is Private. The output of the	-D  option
       is Volatile.

SEE ALSO

       ksh93(1), attributes(5)

SunOS 5.11							    27 Jan 2009 							 shcomp(1)