|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
awk filter based on column value (variable value)
Post 302828431 by kiranredz on Tuesday 2nd of July 2013 12:21:03 PM
07-02-2013
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have a file with colon separated values.. the sample is attached below.
No of fields in each record/line is dependent on the value of field53.
What I need to do is to design a special filter based on specific requirement of some match of values in particular column or combination of columns.
... (2 Replies)
Discussion started by: rraajjiibb
2 Replies
2. Shell Programming and Scripting
I want to accomplish this in sh, however if the capability exists only in other shells elsewhere that's acceptable.
% df -kh
Filesystem size used avail capacity Mounted on
...
/dev/dsk/c0t0d0s1 103G 102G 23M 100% /export/DISK15
...
# output... (5 Replies)
Discussion started by: ProGrammar
5 Replies
3. Shell Programming and Scripting
Hi all
This is my output of the some SQL Query
TABLESPACE_NAME FILE_NAME TOTALSPACE FREESPACE USEDSPACE Free
------------------------- ------------------------------------------------------- ---------- --------- ---------... (2 Replies)
Discussion started by: jhon
2 Replies
4. Shell Programming and Scripting
I want to found the parent process of the current parent process.
I use the following script.
ps -ef|grep -v grep |awk $3==$PPID print {$8}
It is prompt the following error message:
awk: 0602-500 Quitting The source line is 1.
I am using AIX 6.1.
Would you tell me what wrong of the... (2 Replies)
Discussion started by: cstsang
2 Replies
5. Linux
I have a .CSV file with the below format:
"column 1","column 2","column 3","column 4","column 5","column 6","column 7","column 8","column 9","column 10
"12310","42324564756","a simple string with a , comma","string with or, without commas","string 1","USD","12","70%","08/01/2013",""... (2 Replies)
Discussion started by: dhruuv369
2 Replies
6. Shell Programming and Scripting
Hi all:
How do I use an `awk` like:
awk '{print $1 "\t" $2}' input
on the following input:
<head>medium-n</head> nmod+ns+ns-map-n
<head>future-n</head> of+n-the+ns-map-n
to achieve the following desired output:
medium-n nmod+ns+ns-map-n
future-n of+n-the+ns-map-n (3 Replies)
Discussion started by: owwow14
3 Replies
7. Shell Programming and Scripting
Hi All,
I am trying to select the rows in a fixed width file based on values in the columns.
I want to select only the rows if column position 3-4 has the value AB
I am using cut command to get the column values. Is it possible to check if cut -c3-4 = AB is true then select only that... (2 Replies)
Discussion started by: ashok.k
2 Replies
8. Shell Programming and Scripting
Hello Team,
Need your expertise on following:
Here is the set of data:
C1|4|C1SP1|A1|C1BP1|T1
C1|4|C1SP2|A1|C1BP2|T2
C2|3|C2SP1|A2|C2BP1|T2
C3|3|C3SP1|A3|C3BP1|T2
C2|2|C2SP2|A2|C2BP2|T1
I need to filter above date base on following two steps:
1. Group them by column 1 and 4
2.... (12 Replies)
Discussion started by: angshuman
12 Replies
9. Shell Programming and Scripting
The below awk will filter a list of 30,000 lines in the tab-delimited file. What I am having trouble with is adding a condition to SVTYPE=CNV
that will only print that line if CI= must be >.05 .
The other condition to add is if SVTYPE=Fusion, then in order to print that line
READ_COUNT must... (3 Replies)
Discussion started by: cmccabe
3 Replies
10. Shell Programming and Scripting
Hello
I have a tab text file with many columns and have to filter rows ONLY if column 22 has the value of '0', '1', '2' or '3' (out of 0-5).
If Column 22 has value '0','1', '2' or '3' (highlighted below), then remove anything less than 10 and greater 100 (based on column 5) AND remove anything... (1 Reply)
Discussion started by: nans
1 Replies
LEARN ABOUT ULTRIX
doesbackingstore
BlackPixelOfScreen(3X11) MIT X11R4 BlackPixelOfScreen(3X11) Name BlackPixelOfScreen, WhitePixelOfScreen, CellsOfScreen, DefaultColormapOfScreen, DefaultDepthOfScreen, DefaultGCOfScreen, DefaultVisualOf- Screen, DoesBackingStore, DoesSaveUnders, DisplayOfScreen, XScreenNumberOfScreen, EventMaskOfScreen, HeightOfScreen, HeightMMOfScreen, Max- CmapsOfScreen, MinCmapsOfScreen, PlanesOfScreen, RootWindowOfScreen, WidthOfScreen, WidthMMOfScreen - screen information functions and macros Syntax BlackPixelOfScreen(screen) WhitePixelOfScreen(screen) CellsOfScreen(screen) DefaultColormapOfScreen(screen) DefaultDepthOfScreen(screen) DefaultGCOfScreen(screen) DefaultVisualOfScreen(screen) DoesBackingStore(screen) DoesSaveUnders(screen) DisplayOfScreen(screen) int XScreenNumberOfScreen(screen) Screen *screen; EventMaskOfScreen(screen) HeightOfScreen(screen) HeightMMOfScreen(screen) MaxCmapsOfScreen(screen) MinCmapsOfScreen(screen) PlanesOfScreen(screen) RootWindowOfScreen(screen) WidthOfScreen(screen) WidthMMOfScreen(screen) Arguments screen Specifies a pointer to the appropriate structure. Description The macro returns the black pixel value of the specified screen. The macro returns the white pixel value of the specified screen. The macro returns the number of colormap cells in the default colormap of the specified screen. The macro returns the default colormap of the specified screen. The macro returns the default depth of the root window of the specified screen. The macro returns the default GC of the specified screen, which has the same depth as the root window of the screen. The macro returns the default visual of the specified screen. The macro returns or which indicate whether the screen supports backing stores. The macro returns a Boolean value indicating whether the screen supports save unders. The macro returns the display of the specified screen. The function returns the screen index number of the specified screen. The macro returns the root event mask of the root window for the specified screen at connection setup. The macro returns the height of the specified screen. The macro returns the height of the specified screen in millimeters. The macro returns the maximum number of installed colormaps supported by the specified screen. The macro returns the minimum number of installed colormaps supported by the specified screen. The macro returns the number of planes in the root window of the specified screen. The macro returns the root window of the specified screen. The macro returns the width of the specified screen. The macro returns the width of the specified screen in millimeters. See Also AllPlanes(3X11), ImageByteOrder(3X11), IsCursorKey(3X11) X Window System: The Complete Reference, Second Edition, Robert W. Scheifler and James Gettys BlackPixelOfScreen(3X11)