Sponsored Content
Top Forums Shell Programming and Scripting Grep special pattern in 3rd column Post 302724769 by pamu on Thursday 1st of November 2012 09:23:47 AM
Old 11-01-2012
If you want to grep 20 then why you need to sort...?

Quote:
Originally Posted by kayak
Code:
1000 000001 (92.431343802235503, 90.0)
1000 000002 (87.568656197764497, 80.0)
1000 000003 (150.75815307316083, 150.0)
1000 000004 (29.241846926839159, 20.0)
1000 000005 (110.02128542766, 110.0)
1000 000006 (69.978714572339996, 60.0)
1000 000007 (86.093858223079451, 80.0)
1000 000008 (93.906141776920549, 90.0)
1000 000009 (72.905069709350556, 70.0)
1000 000010 (107.09493029064944, 100.0)

Which 20..?
assuming below from 8th column.

Code:
$ awk '$3 ~ /20/' file
1000 000008 (93.906141776920549, 90.0)

and

last column

Code:
$ awk '$NF ~ /20/' file
1000 000004 (29.241846926839159, 20.0)


Last edited by pamu; 11-01-2012 at 10:38 AM..
This User Gave Thanks to pamu For This Post:
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

grep data on 2nd line and 3rd column

How do I grep/check the on-hand value on the second line of show_prod script below? In this case it's a "3". So if it's > 0, then run_this, otherwise, quit. > ./show_prod Product Status Onhand Price shoe OK 3 1.1 (6 Replies)
Discussion started by: joker_789us
6 Replies

2. Shell Programming and Scripting

SED equivalent for grep -w -f with pattern having special characters

I'm looking for SED equivalent for grep -w -f. All I want is to search a list of patterns from a file. Also If the pattern doesn't match I do not want "null returned", rather I would prefer some text as place holder say "BLANK LINE" as I intend to process the output file based on line number. ... (1 Reply)
Discussion started by: novice_man
1 Replies

3. 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... (3 Replies)
Discussion started by: ckmehta
3 Replies

4. Shell Programming and Scripting

grep based on pattern in a line and print the column before that

$ cat file.log Message Number = : Sending message 10:50:16^|^reqhdr.dummyid^=^02^|^reqhdr.timezone^=^GMT+05:30^|^DUMMYREQUEST^=^BH||||||||||||||||||$BD|OL|C|V||DummyAcctNo|02||24/12/2011|ST_DDM|DDM||||||||reqUUID110612105016$BT||||||||||||||||||$] Length I have the above line in the... (4 Replies)
Discussion started by: kalidass
4 Replies

5. UNIX for Dummies Questions & Answers

Search word in 3rd column and move it to next column (4th)

Hi, I have a file with +/- 13000 lines and 4 column. I need to search the 3rd column for a word that begins with "SAP-" and move/skip it to the next column (4th). Because the 3rd column need to stay empty. Thanks in advance.:) 89653 36891 OTR-60 SAP-2 89653 36892 OTR-10 SAP-2... (2 Replies)
Discussion started by: AK47
2 Replies

6. Shell Programming and Scripting

Grep correct pattern with special character and variables

cat file time="north_south_east_west_08:00" location="A" start="left" status="ok" end="north" time="north_south_east_west_12:00" location="C" start="right" status="ok" end="south" time="north_south_east_west_23:00" location="G" start="left" status="ok" end="east"... (7 Replies)
Discussion started by: ctphua
7 Replies

7. Shell Programming and Scripting

sed and awk usage to grep a pattern 1 and with reference to this grep a pattern 2 and pattern 3

Hi , I have a file where i have modifed certain things compared to original file . The difference of the original file and modified file is as follows. # diff mir_lex.c.modified mir_lex.c.orig 3209c3209 < if(yy_current_buffer -> yy_is_our_buffer == 0) { --- >... (5 Replies)
Discussion started by: breezevinay
5 Replies

8. Shell Programming and Scripting

Solution for replacement of 4th column with 3rd column in a file using awk/sed preserving delimters

input "A","B","C,D","E","F" "S","T","U,V","W","X" "AA","BB","CC,DD","EEEE","FFF" required output: "A","B","C,D","C,D","F" "S", T","U,V","U,V","X" "AA","BB","CC,DD","CC,DD","FFF" tried using awk but double quotes not preserving for every field. any help to solve this is much... (5 Replies)
Discussion started by: khblts
5 Replies

9. UNIX for Beginners Questions & Answers

UNIX script to compare 3rd column value with first column and display

Hello Team, My source data (INput) is like below EPIC1 router EPIC2 Targetdefinition Exp1 Expres rtr1 Router SQL SrcQual Exp1 Expres rtr1 Router EPIC1 Targetdefinition My output like SQL SrcQual Exp1 Expres Exp1 Expres rtr1 Router rtr1 Router EPIC1 Targetdefinition... (5 Replies)
Discussion started by: sekhar.lsb
5 Replies

10. UNIX for Beginners Questions & Answers

If pattern in column 3 matches pattern in column 2 (any row), print value in column 1

Hi all, I have searched and searched, but I have not found a solution that quite fits what I am trying to do. I have a long list of data in three columns. Below is a sample: 1,10,8 2,12,10 3,13,12 4,14,14 5,15,16 6,16,18 Please use code tags What I need to do is as follows: If a... (4 Replies)
Discussion started by: bleedingturnip
4 Replies
XvGetPortAttribute(3)						  libXv Functions					     XvGetPortAttribute(3)

NAME
XvGetPortAttribute - return current port attribute value SYNOPSIS
#include <X11/extensions/Xvlib.h> int XvGetPortAttribute(Display *dpy, XvPortID port, Atom attribute, int p_value); ARGUMENTS
dpy Specifies the connection to the X server. port Specifies the port, associated with the given display, for which the attribute values are to be returned. attribute An atom that identifies the attribute to be queried by this request. Control atoms are obtained using the XInternAtom request with a string from the following table. p_value Pointer to the location where the attribute value is written on return. DESCRIPTION
XvGetPortAttribute(3) returns the current value of the requested port attribute in the integer pointed to by p_value. The attribute is identified using an Atom that equates to the attribute name. The XInternAtom request can be used with one of the strings below to return a matching Atom. ----------------------------------------------------- Attribute String Type Default ----------------------------------------------------- "XV_ENCODING" XvEncodingID Server dependent "XV_HUE" [-1000...1000] 0 "XV_SATURATION" [-1000...1000] 0 "XV_BRIGHTNESS" [-1000...1000] 0 "XV_CONTRAST" [-1000...1000] 0 RETURN VALUES
[Success] Returned if XvGetPortAttribute(3) completed successfully. [XvBadExtension] Returned if the Xv extension is unavailable. [XvBadAlloc] Returned if XvGetPortAttribute(3) failed to allocate memory to process the request. DIAGNOSTICS
[XvBadPort] Generated if the requested port does not exist. [BadMatch] Generated if the requested attribute atom does not specify an attribute supported by the adaptor. SEE ALSO
XvSetPortAttribute(3), XvPortNotify(3) X Version 11 libXv 1.0.7 XvGetPortAttribute(3)
All times are GMT -4. The time now is 09:41 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy