10 More Discussions You Might Find Interesting
1. UNIX for Beginners Questions & Answers
Hello Experts,
I was trying to awk out some data out of a text file.
Below is a sample file which I have
xxx ***Wed Jun 28 18:00:59 CDT 2015
avg-cpu: %user %nice %system %iowait %steal %idle
17.10 0.00 4.56 2.86 0.00 75.48
Device: rrqm/s wrqm/s ... (2 Replies)
Discussion started by: DevAnand
2 Replies
2. Shell Programming and Scripting
i want to grab lines from a file that are between two patterns (including the lines that contain the pattern).
here's what im currently doing:
data.txt
aaa
bbb
cccc
ddd
eee
ffff
ddd
code:
awk '/bbb/,/fff/ && $0 !~ /ddd/' cdsnmp.sh
I want to grab lines between and including bbb... (5 Replies)
Discussion started by: SkySmart
5 Replies
3. UNIX for Beginners Questions & Answers
I have two csv files of different sizes. The output file needs to have file1 contents on top of file2 contents where file2 col1 is >= to file1 col1, and file2 col1(same value) is < file1 col1 (next value). So basically, some file2 rows will be matched to the same file1 row because it is the closet... (7 Replies)
Discussion started by: aachave1
7 Replies
4. Shell Programming and Scripting
i'm aware awk can do what i'm trying to do here. but i cant use awk in this scenario given the circumstance of this box.
but i need to check if a number is a certain column is over a certain value, say for instance, 20.
data:
| 12 | 19 | 2000 | 9029333 |... (11 Replies)
Discussion started by: SkySmart
11 Replies
5. Shell Programming and Scripting
A file
2400 2800 PSC000289
3200 3896 PCS000289
3333 3666 PCS000221
222 1000 PCS000222
3299 3600 PSC000289
Question is while if third column is PCS000289
and first column should be greater than 3000, then replace PCS000289 by YES,
remaining the others column same.
... (1 Reply)
Discussion started by: cdfd123
1 Replies
6. UNIX for Dummies Questions & Answers
I have a data file that has 14 columns. I cannot use awk or perl but sed is installed on my host. I would like to delete a line if fields 10, 11 or twelve is greater than 999.99. How is this done using sed? :wall:
sed '/^*,*,*,*,*,*,*,*,*,*,*,*,*,*,/d' infile
1 2 3 4 ... (2 Replies)
Discussion started by: Chris Eagleson
2 Replies
7. Shell Programming and Scripting
my files are as follows
fileA sepearated by tab /t
00 lieferungen
00 attractiop
01 done
02 forness
03 rasp
04 alwaysisng
04 funny
05 done1
fileB
funnymou120112
funnymou234470
mou3raspnhdhv
rddfgmoudone1438748
so all those record which are greater than 3 and which are not... (4 Replies)
Discussion started by: rajniman
4 Replies
8. Shell Programming and Scripting
Hi, as the title states i need to find a way to search a column for values great than 1000, and if it is, then delete that row.
An example
1 7.021 6.967 116.019 4 U 6.980E+07 0.000E+00 e 0 0 0 0
2 8.292 7.908 118.063 3 U 1.440E+07 0.000E+00 e 0 821 814 ... (3 Replies)
Discussion started by: olifu02
3 Replies
9. Shell Programming and Scripting
We have an access log where column 8 displays the time in seconds like below:
Tj8nQAoNgwsAABov9cIAAAFL - 10.13.131.80 - - (0) - "GET /aaaaa/bbbb/bbbb
where column 8 is printed (0). We are trying to find how many entries are there that has column 8 greater than 0.
Remember $8 is (0) and not... (5 Replies)
Discussion started by: spacemtn5
5 Replies
10. Shell Programming and Scripting
I am using awk command for greping an value from the file
the file contains ..
file
----------------------------
content-----------
--------
String main = "81507066666";
------------------------------
i am greping the above value using awk command
NumberToReplace=`cat "file" | grep... (1 Reply)
Discussion started by: vastare
1 Replies