Select rows where the 3rd column value is over xx Post: 302476224

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk to select rows based on condition on column

I have got a file like this 003ABC00281020091005000100042.810001 ...

2. 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. UNIX for Dummies Questions & Answers

merging rows into new file based on rows and first column

I have 2 files, file01= 7 columns, row unknown (but few) file02= 7 columns, row unknown (but many) now I want to create an output with the first field that is shared in both of them and then subtract the results from the rest of the fields and print there e.g. file 01 James|0|50|25|10|50|30...

4. Shell Programming and Scripting

Select distinct rows in a file by last column

Hi, I have the following file: LOG:015608::ERR:2310:map_spsrec:Invalid parameter LOG:015608::ERR:2471:map_dgdrec:Invalid parameter LOG:015608::ERR:2487:map_nnmrec:Invalid number LOG:015608::ERR:2310:map_nmrec:Invalid number LOG:015608::ERR:2438:map_nmrec:Invalid number As a delimiter I...

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

6. Shell Programming and Scripting

Changing values only in 3rd column and 4th column

#cat file testing test! nipw asdkjasjdk ok! what !ok host server1 check_ssh_disk!102.56.1.101!30!50!/ other host server 2 des check_ssh_disk!192.6.1.10!40!30!/ #grep check file| awk -F! '{print $3,$4}'|awk '{gsub($1,"",$1)}1' 50 30 # Output:

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

8. UNIX for Beginners Questions & Answers

How to select rows that have opposite values (A vs B, or B vs A) on first two columns?

I have a dateset like this: Gly1 Gly2 2 1 0 Gly3 Gly4 3 4 5 Gly3 Gly5 1 3 2 Gly2 Gly1 3 6 2 Gly4 Gly3 2 2 1 Gly6 Gly4 4 2 1what I expected is: Gly1 Gly2 2 1 0 Gly2 Gly1 3 6 2 Gly3 Gly4 3 4 5 Gly4 Gly3 2 2 1 A vs B, or B vs A are the same...

9. Shell Programming and Scripting

Average select rows

I have no idea how to even get started with this script. I need to average field 3 for each of the unique identifiers found in field 1. However, I only want to average these rows when field 2 is equal to 1506 - 2000 (note that i replaced the values field 2 for security reasons, but the real...

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

LEARN ABOUT DEBIAN

vuname

VIEW-OS(1)						      General Commands Manual							VIEW-OS(1)

NAME

       vuname - print view information

SYNOPSIS

       vuname [OPTION]...

DESCRIPTION

       Print certain view information.	With no OPTION, same as -s.

OPTIONS

       -a, --all
	   print all information, in the following order, except omit -p and -i if unknown.

       -s, --kernel-name
	   print the kernel name

       -n, --nodename
	   print the network node hostname

       -r, --kernel-release
	   print the kernel release

       -v, --kernel-version
	   print the kernel version

       -m, --machine
	   print the machine hardware name

       -p, --processor
	   print the processor type or "unknown"

       -i, --hardware-platform
	   print the hardware platform or "unknown"

       -o, --operating-system
	   print the operating system

       -U, --serverid
	   print the view-os server id

       -V, --viewid
	   print the view id

       -N, --viewname
	   print the view name

       -x, --nouname
	   do not use uname (without this flag the command behaves like uname		when it runs on a non View-OS enabled environment).

       -q, --quiet
	   quiet mode: error messages suppressed

       --help
	   display a help message and exit

       --version
	   output version information and exit

SEE ALSO

       umview(1),uname(1)

AUTHORS

       View-OS is a project of the Computer Science Department, University of Bologna. Project Leader: Renzo Davoli.
       <http://www.sourceforge.net/projects/view-os>

       Howto's and further information can be found on the project wiki <wiki.virtualsquare.org>.

VIEW-OS: a process with a view					   June 11, 2007							VIEW-OS(1)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk to select rows based on condition on column

Discussion started by: Maruti

2. Shell Programming and Scripting

AWK script to create max value of 3rd column, grouping by first column

Discussion started by: ckmehta

3. UNIX for Dummies Questions & Answers

merging rows into new file based on rows and first column

Discussion started by: A-V

4. Shell Programming and Scripting

Select distinct rows in a file by last column

Discussion started by: apenkov