awk command to print only selected rows in a particular column specified by column name Post: 302695097

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

flags to suppress column output, # of rows selected in db2 sql in UNIX

Hello, I am new to db2 SQL in unix so bear with me while I try to explain the situation. I have a text file that has the contents of the where condition that I am using for a db2 SQL in UNIX ksh. Here is the snippet. if ; then echo "Begin processing VALUEs" ...

2. Shell Programming and Scripting

print selected rows with awk

Hi everybody: Could anybody tell me how I can print from a file a selected rows with awk. In my case I only want print in another file all the rows from NR=8 to NR=2459 and the increment each 8 times. I tried to this: awk '{for (i=8; i=2459; i+=8); NR==i}' file1 > file2 But doesn't...

3. Shell Programming and Scripting

find expression with awk in only one column, and if it fits, print whole column

Hi. How do I find an expression with awk in only one column, and if it fits, then print that whole column. 1 apple oranges 2 bannanas pears 3 cats dogs 4 hesaid shesaid echo "which number:" read NUMBER (user inputs number 2 for this example) awk " /$NUMBER/ {field to search is field...

4. Shell Programming and Scripting

Awk to add selected row column data

Looks at the most efficient way to add up the column of data based off of the rows. Random data Name-Number-ID Sarah-2.0-15 Bob-6.3-15 Sally-1.0-10 James-1.0-10 Scotty-10.7-15 So I would select all those who have ID = 15 and then add up total number read - p "Enter ID number" Num ...

5. Shell Programming and Scripting

Please Help!!!! Awk for summing columns based on selected column value

a,b,d,e,f,g,h,i,j,k,l,m,n,o,p,q,r,s,t,u,v,w,x,y,z,aa,bb,cc,dd,ee,ff,gg,hh,ii a thru ii are digits and strings.... The awk needed....if coloumn 9 == i (coloumn 9 is string ), output the sum of x's(coloumn 22 ) in all records and sum of y's (coloumn 23 ) in all records in a file (records.txt)....

6. UNIX for Dummies Questions & Answers

Print rows with substring in column

Hi I want to print all rows where there is the alphabet N in the 6th column as a substring. Here is what i tried and not working.Please help ! awk ' { if ( $6 == *"N"* ) print $0} ' awk ' { if ( "${6}" == *N* ) print $0} ' awk ' { if( grep -q N <<<$6) print $0} '

7. 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...

8. Shell Programming and Scripting

Print column details from fixed width file using awk command

hi, i have a fixed width file with multiple columns and need to print data using awk command. i use: awk -F "|" '($5 == BH) {print $1,$2,$3}' <non_AIM target>.txt for a delimiter file. but now i have a fixed width file like below: 7518 8269511BH 20141224951050N8262 11148 8269511BH...

9. Shell Programming and Scripting

Combine multiple rows based on selected column keys

Hello I want to collapse a file with multiple rows into consolidated lines of entries based on selected columns as the 'key'. Example: 1 2 3 Abc def ghi 1 2 3 jkl mno p qrts 6 9 0 mno def Abc 7 8 4 Abc mno mno abc 7 8 9 mno mno abc 7 8 9 mno j k So if columns 1, 2 and 3 are...

10. Shell Programming and Scripting

Need awk or Shell script to compare Column-1 of two different CSV files and print if column-1 matche

Example: I have files in below format file 1: zxc,133,joe@example.com cst,222,xyz@example1.com File 2 Contains: hxd hcd jws zxc cst File 1 has 50000 lines and file 2 has around 30000 lines : Expected Output has to be : hxd hcd jws

LEARN ABOUT BSD

col

COL(1)							      General Commands Manual							    COL(1)

NAME

       col - filter reverse line feeds

SYNOPSIS

       col [ -bfh ]

DESCRIPTION

       Col  reads the standard input and writes the standard output.  It performs the line overlays implied by reverse line feeds (ESC-7 in ASCII)
       and by forward and reverse half line feeds (ESC-9 and ESC-8).  Col is particularly useful for filtering multicolumn output  made  with  the
       `.rt' command of nroff and output resulting from use of the tbl(1) preprocessor.

       Although  col  accepts  half  line motions in its input, it normally does not emit them on output.  Instead, text that would appear between
       lines is moved to the next lower full line boundary.  This treatment can be suppressed by the -f (fine) option; in  this  case  the  output
       from col may contain forward half line feeds (ESC-9), but will still never contain either kind of reverse line motion.

       If  the	-b  option is given, col assumes that the output device in use is not capable of backspacing.  In this case, if several characters
       are to appear in the same place, only the last one read will be taken.

       The control characters SO (ASCII code 017), and SI (016) are assumed to start and end text in an alternate character  set.   The  character
       set  (primary or alternate) associated with each printing character read is remembered; on output, SO and SI characters are generated where
       necessary to maintain the correct treatment of each character.

       If the -h option is given, col converts white space to tabs to shorten printing time.

       All control characters are removed from the input except space, backspace, tab, return, newline, ESC (033) followed by one of 7, 8, 9,  SI,
       SO,  and  VT (013).  This last character is an alternate form of full reverse line feed, for compatibility with some other hardware conven-
       tions.  All other non-printing characters are ignored.

SEE ALSO

       troff(1), tbl(1)

BUGS

       Can't back up more than 128 lines.
       No more than 800 characters, including backspaces, on a line.

7th Edition							   May 16, 1986 							    COL(1)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

flags to suppress column output, # of rows selected in db2 sql in UNIX

Discussion started by: jerardfjay

2. Shell Programming and Scripting

print selected rows with awk

Discussion started by: tonet

3. Shell Programming and Scripting

find expression with awk in only one column, and if it fits, print whole column

Discussion started by: glev2005

4. Shell Programming and Scripting

Awk to add selected row column data

Discussion started by: Ironguru

5. Shell Programming and Scripting

Please Help!!!! Awk for summing columns based on selected column value

Discussion started by: BrownBob

6. UNIX for Dummies Questions & Answers

Print rows with substring in column

Discussion started by: newbie83

7. Shell Programming and Scripting

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

Discussion started by: jacobs.smith