11-04-2009
awk to select rows based on condition on column
I have got a file like this
003ABC00281020091005000100042.810001
003ABC01281020091005000100042.810001
003DEF00281020091005000100044.180001
003DEF01281020091005000100044.180001
003GHI00281020091005000100046.130001
003GHI01281020091005000100046.130001
003DKK00281020091005000100009.370001
i want output like this
003ABC00281020091005000100042.810001
003DEF00281020091005000100044.180001
003GHI00281020091005000100046.130001
003DKK00281020091005000100009.370001
i mean i want to select rows only when 8th character of the line is 0... Is it possible to do it using awk...pls help...
(pls ignore the space between lines
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Problem,
How can you pass today's date (eg) 18 into Awk and select the field representing the 18th column?
I have an output that I want to interact with based on what day it is
information=0:0 192:0 5436:0 22:99 0:0 0:0 1234:0 1359:09
DAY=date'+%d'
numbrs=`$information | awk... (2 Replies)
Discussion started by: Gizmo1007
2 Replies
2. Shell Programming and Scripting
Hi All,
I've got a text file which is Postcode,Postcode, Travel_time and I want to select all of the rows where the 3rd column value is over 255. Can someone show me the magic on how to do this?
Originally it did contain 4 columns but i've managed to strip out the first 3 using:
cat textfile |... (3 Replies)
Discussion started by: gman
3 Replies
3. Shell Programming and Scripting
Hi,
I'm using AIX(ksh shell).
> cat temp.txt
"a","b",0
"c",bc",0
"a1","b1",0
"cc","cb",1
"cc","b2",1
"bb","bc",2
I want the output as:
"a","b","c","bc","a1","b1"
"cc","cb","cc","b2"
"bb","bc"
I want to combine multiple lines into single line where third column is same.
Is... (1 Reply)
Discussion started by: samuelray
1 Replies
4. UNIX for Dummies Questions & Answers
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... (1 Reply)
Discussion started by: A-V
1 Replies
5. Shell Programming and Scripting
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... (2 Replies)
Discussion started by: apenkov
2 Replies
6. Shell Programming and Scripting
I have two files file1.txt and file2.txt.
want to print some column(number,status,date1,date2,description(descrption column end before category column start with'Oracle Services') and assigned_to column from file1.txt ...If the assigned_to name in file2.txt matches with assinged_to name in... (2 Replies)
Discussion started by: vijay_rajni
2 Replies
7. Shell Programming and Scripting
I have a file some thing like this:
GN Name=YWHAB;
RC TISSUE=Keratinocyte;
RC TISSUE=Thymus;
CC -!- FUNCTION: Adapter protein implicated in the regulation of a large
CC spectrum of both general and specialized signaling pathways
GN Name=YWHAE;
RC TISSUE=Liver;
RC ... (13 Replies)
Discussion started by: raj_k
13 Replies
8. Shell Programming and Scripting
All,
I have a text file(Inputfile.csv) with millions of rows and 100 columns. Check the sample for 2 columns below.
Key,Check
A,1
A,2
A,
A,4
B,0
B,1
B,2
B,3
B,4
....
million rows.
My requirement is to delete all the rows corresponding to all the keys which ever has at least one... (4 Replies)
Discussion started by: ks_reddy
4 Replies
9. UNIX for Advanced & Expert Users
HI,
My Input file data is
dn:adcfgeneral
id:13343
Name:xxxxxx
Password:iutyerwuitywue wpuwt
tuiytruityrutyrwtyrwp
dn:cdferwjyyyy
id:3875
Name:yyyy
Password :hgfdsjkfhdsfkdlshf
dshfkldshfdklsfh
interset:uiuiufj
My output should be
... (6 Replies)
Discussion started by: dineshaila
6 Replies
10. Shell Programming and Scripting
Hello,
I want to get the maximum value of each record separated by empty line based on the 3rd column of each row within each record?
Input:
A1 chr5D 634 7 82 707
A2 chr5D 637 6 82 713
A3 chr5D 637 5 82 713
A4 chr5D 626 1 82 704... (4 Replies)
Discussion started by: yifangt
4 Replies
LEARN ABOUT DEBIAN
synce-pls
PLS(1) http://synce.sourceforge.net/ PLS(1)
NAME
pls - list directory contents
SYNOPSIS
pls [-a] [-R] [-d LEVEL] [-p DEVNAME] [-h] [DIRECTORY]
DESCRIPTION
pls list the contents of a directory on a device connected through SynCE.
Forward slashes ('/') on the command line are converted to backward slashes ('').
File attributes
A Archive
C Compressed
D Directory
H Hidden
I In ROM
M ROM module (can only be executed, not read!)
N Normal
R Read-only
S System
T Temporary
OPTIONS
-d LEVEL
Set debug log level:
0 - No logging (default)
1 - Errors only
2 - Errors and warnings
3 - Everything
-p DEVNAME
Use the device with the given name, instead of the default.
-a Show all files including those marked as hidden.
-R Recursively list subdirectories.
-h Display help message.
DIRECTORY
The full path name to the directory. Wild cards are allowed, but only for the trailing part of the path, and should be protected
from the shell. If this parameter is relative, it is assumed to be relative to the "My Documents" folder. Similarly, if this parame-
ter is omitted, the contents of the "My Documents" folder is listed.
AUTHOR
This manual page was written by David Eriksson <twogood@users.sourceforge.net>.
SEE ALSO
synce(1) pcp(1) pls(1) prm(1) pmkdir(1) prmdir(1)
The SynCE project November 2002 PLS(1)