10 More Discussions You Might Find Interesting
1. 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
2. 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
3. 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
4. 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
5. 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
6. 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
7. 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
8. 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
9. 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
10. 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