10-07-2010
Simple AWK question
Hi,
let's assume i have an output below:
orgauser 23826 :E:Validity
senerse 2096
senerse 2111
senerse 21585
senerse 21596
root 12653 -bash
root 17262
root 17278
Some lines have not any string in their third column. I don't want to see those lines. i just want to see the lines which have strings in the third column.
So, output should be as below:
orgauser 23826 :E:Validity
root 12653 -bash
How can i do that? Any help would be greatly appreciated
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I'm a total beginner at awk and hope someone can advise what I have done wrong in the following script:
I have a file which (to simplify things) may be something like this
Fred Smith and Sue Brown
Joe Jones and Jane Watts
Sally Green and Jim O?
Connor
Freda O?
Reiley and Pat O?... (2 Replies)
Discussion started by: Bab00shka
2 Replies
2. Shell Programming and Scripting
Trying to write an if statement, which calls2 or 3 functions from within it.
code:
{if (($34 != "") && (NR != 1) && ($1 != "F"))
less_than(34, 0, "S1002a")
is_number(34,"S1002a")
}
But this is only treating the first function call, as part of the if.
and always executes is_number.... (1 Reply)
Discussion started by: natdeamer
1 Replies
3. UNIX for Dummies Questions & Answers
Hello,
I'm trying to use awk to print lines that match a regular expression.
I am using awk to print a record only if it contains N/A.
awk '/N/A/ {print $1}'
When executed the script returns "awk syntax error near line 1".
If I use /N//A/ it prints all records containing a "/", not... (2 Replies)
Discussion started by: orahi001
2 Replies
4. UNIX for Dummies Questions & Answers
Hi ,
I have a simple question in awk, i have long string which i am getting for a grep command. the output contains 50 fields.
I need to display like first 5 fileds in a line and rest of all fields in the next line.
{ for(i=5;i<NF;++i) s= $i; print $1,$2,$3,$4,$5,"\n",$s}
Is the above... (1 Reply)
Discussion started by: senthilkumar_ak
1 Replies
5. Shell Programming and Scripting
I have a file
CREATE TABLE DDD_EXT --- 1000
(
val u1
val u1
);
CREATE TABLE dsdasd_EXT --- 1323
(
val u1
val u1
);
CREATE TABLE AAAAAA_EXT --- 1222
(
val u1
val u1
);
CREATE TABLE E_EXT --- 11
(
val u1
val u1 (2 Replies)
Discussion started by: jville
2 Replies
6. Shell Programming and Scripting
Hi,
Probably a very weak question.. but I have tried all I know..
BPC0001:ANNUL_49542 0.0108 -0.0226 -0.0236 0.0042 0.0033 -0.0545 0.0376 0.0097 -0.0093 -0.032 Control
BPC0002:ANNUL_49606 0.0190 -0.0142 -0.0060 -0.0217 -0.0027 ... (3 Replies)
Discussion started by: genehunter
3 Replies
7. UNIX for Dummies Questions & Answers
Can anyone tell me please what the "+" is doing in this awk command?
find / -user smith -type f -ls | awk '{ sum += $7 } END {print sum }'
Thanks,
George (2 Replies)
Discussion started by: george_vandelet
2 Replies
8. Shell Programming and Scripting
Hi All,
A very silly question:
How to just print the integer attached a particular string in a line by awk?
Ex:
Happy_world_foo123...So i just want the value 123 to be printed on the line where we have string "foo".
Thanks (16 Replies)
Discussion started by: Indra2011
16 Replies
9. Shell Programming and Scripting
I have what a think is a simple question but I'm just a beginner in scripting. I'm my unix command line I run a date command that returns the following:
Wed Apr 3 10:39:30 EDT 2013
How do I awk out the "10" only in awk? Or is awk the way to do it or is there a better way? (7 Replies)
Discussion started by: scj2012
7 Replies
10. Shell Programming and Scripting
Here is an awk line I have in a bigger script that checks to see if nimsh process is running and does couple other things based on the output and runs on all servers.
ps -ef|grep -i nimsh|awk '{print $9}' and I am expecting output to be "/usr/sbin/nimsh"
I find that on some servers... (4 Replies)
Discussion started by: kvosu
4 Replies
LEARN ABOUT CENTOS
funindex
funindex(1) SAORD Documentation funindex(1)
NAME
funindex - create an index for a column of a FITS binary table
SYNOPSIS
funindex <switches> <iname> [oname]
OPTIONS
NB: these options are not compatible with Funtools processing. Please
use the defaults instead.
-c # compress output using gzip"
-a # ASCII output, ignore -c (default: FITS table)"
-f # FITS table output (default: FITS table)"
-l # long output, i.e. with key value(s) (default: long)"
-s # short output, i.e. no key value(s) (default: long)"
DESCRIPTION
The funindex script creates an index for the specified column (key) by running funtable -s (sort) and then saving the column value and the
record number for each sorted row. This index will be used automatically
by funtools filtering of that column, provided the index file's modification date is later than that of the data file.
The first required argument is the name of the FITS binary table to index. Please note that text files cannot be indexed at this time. The
second required argument is the column (key) name to index. While multiple keys can be specified in principle, the funtools index process-
ing assume a single key and will not recognize files containing multiple keys.
By default, the output index file name is [root]_[key].idx, where [root] is the root of the input file. Funtools looks for this specific
file name when deciding whether to use an index for faster filtering. Therefore, the optional third argument (output file name) should not
be used for funtools processing.
For example, to create an index on column Y for a given FITS file, use:
funindex foo.fits Y
This will generate an index named foo_y.idx, which will be used by funtools for filters involving the Y column.
SEE ALSO
See funtools(7) for a list of Funtools help pages
version 1.4.2 January 2, 2008 funindex(1)