06-03-2009
zip code filter problem using AWK need help
Hello all;
I have a large file (csv file) with addresses. I am trying to filter out specific entries based on zip code from a particular column of data. However my awk statement can not account for zipcode that begins with a certain pattern. It finds the pattern anywhere within the zipcode. Zipcodes have been entered either using the 5 digit method or 9 digit method (no hypen). I have tried the ^ option but it does not seem to work.
Here is my example that works but needs editing:
awk -F"," '($25 ~ /[1][2][3][0-9][0-9]/)' infile > outfile
have tried
awk -F"," '($25 ~ /^[1][2][3][0-9][0-9]/)' infile > outfile ' doesn't work
Any suggestions would be greatly appreciated.
nelson
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi Folks,
i have a script to zip certain files. redirecting the successfully zipped files and unsuccessful files to seperate files.
i found unzipped file name in zipped file list.
i dont know why it happened.
and, some of the files are not zipped.
i checked the previllege also, even... (2 Replies)
Discussion started by: Arunprasad
2 Replies
2. Shell Programming and Scripting
Anyone can help for filter the uniq record for below example? Thank you very much
Input file
20090503011111|test|abc
20090503011112|tet1|abc|def
20090503011112|test1|bcd|def
20090503011131|abc|abc
20090503011131|bbc|bcd
20090503011152|bcd|abc
20090503011151|abc|abc... (8 Replies)
Discussion started by: bleach8578
8 Replies
3. Shell Programming and Scripting
Hi,
Suppose I have a csv file, each line look like this:
ABC Company, 1999, March, caucasian owned, 123 BroadWay NY 92939-2222
How do I create two new columns at the end, one for state, one for zip.
So that the line is
ABC Company, 1999, March, caucasian owned, 123 BroadWay NY... (2 Replies)
Discussion started by: grossgermany
2 Replies
4. UNIX for Dummies Questions & Answers
Hi friends
I am working in cygwin. Currently I am in root directory(C). I want to zip only the files from a diretory "A" to a new directory 1.zip in root directory C.
I am using the following command:
$: zip 1.zip A/*
but it is zipping the entire directory itself, But what I want is when... (4 Replies)
Discussion started by: ks_reddy
4 Replies
5. Shell Programming and Scripting
I want to filter 2nd column = 2 using awk
$ cat t
1 2
2 4
$ VAR=2
#variable worked in print
$ cat t | awk -v ID=$VAR ' { print ID}'
2
2
# but variable didn't work in awk filter
$ cat t | awk -v ID=$VAR '$2~/ID/ { print $0}' (2 Replies)
Discussion started by: honglus
2 Replies
6. Shell Programming and Scripting
Hi ,
I am having two files like this
FILE1
####################
input SI_TESTONLY_R_00;
input CE0_SE_INPUT_TESTONLY;
input CE0_TCLK_TESTONLY;
input SI_JTGCLOCKDR_JTAG_R_00;
input CE0_TCLK_JTGCLOCKDR_JTAG;
input CE0_SE_INPUT_JTGCLOCKDR_JTAG;
output SO_TESTONLY_R_00;
output... (2 Replies)
Discussion started by: jaita
2 Replies
7. Shell Programming and Scripting
Hi All,
I'm stuck with this issue when I try to display the searched string into a compressed file.
More exactly when I run this script
for f1 in $(find dir1 -type f -print); do gunzip -c $f1 | grep -n "gio" | awk -F":" '{print $1-1 "," $1 "p"}' | xargs -i sed -n {} $f1 ; done
returns... (3 Replies)
Discussion started by: gio1234
3 Replies
8. UNIX for Dummies Questions & Answers
Hi,
I'm trying to combine two files which have 1 column in common and filter out rows I don't need.
File 1:
ID Start End Matched Coverage
1 1 254 1515 5.96
2 1 135 402 2.98
File 2 (has 2 rows per entry):
>1... (4 Replies)
Discussion started by: Yarinka
4 Replies
9. Shell Programming and Scripting
Not sure if this is the correct forum for this question. I have two files. file1.zip, file2
Input:
file1.zip
col1, col2 , col3
a , b , 0:0:0:0:0:c436:9346:d40b
x, y, 0:0:0:0:0:880:39f9:c9a7
m, n , 0:0:0:0:0:80c7:9161:fe00
file2.txt
col1
c4:36:93:46:d4:0b... (1 Reply)
Discussion started by: anil.v
1 Replies
LEARN ABOUT MINIX
make_sockdfr
MAKE_SOCKDFR(8) System Manager's Manual MAKE_SOCKDFR(8)
NAME
make_sockdfr - Generates frozen route file for SOCKS server
SYNOPSIS
make_sockdfr [infile [outfile] ]
DESCRIPTION
make_sockdfr reads in a plain-text route file for the SOCKS server and produces a frozen route file as the output.
Both arguments are optional. The default for infile is /etc/sockd.route; the default for outfile is /etc/sockd.fr. You may specify infile
while omitting outfile, but you cannot specify outfile without also speficying infile.
The contents of the frozen route file is essentially the memory image of the parsed input file. Using the frozen route file can reduce the
start-up delay of the SOCKS server program since it no longer has to parse the file contents.
When the SOCKS server starts, it always looks for the frozen route file /etc/sockd.fr first. If that file is not found, it then tries to
use the plain-text route file /etc/sockd.route. If you use frozen route file, you must remember to run make_sockdfr every time after you
modify the plain-text file or the SOCKS server will continue to use the frozen version of a previous route file.
To find out the contents of a frozen route file, use dump_sockdfr.
FILES
/etc/sockd.fr, /etc/sockd.route
SEE ALSO
dump_sockdfr(8), sockd.fr(5), sockd.route(5)
AUTHOR
Ying-Da Lee, yingda@esd.sgi.com or yingda@best.com
May 6, 1996 MAKE_SOCKDFR(8)