Got a text formatting/database question (bash it to hell?)

2009-04-14 Thread Jim March
Guys, I have an interesting database problem that I think can be solved on the command line in one shot. But I don't know how :(. I have a comma separated values text file. Each line shows a voter ID number and an election ID number they voted in. NOT who they voted for, and not their names,

Re: Got a text formatting/database question (bash it to hell?)

2009-04-14 Thread Charles Jones
$ cat testfile.txt 235,126,Early Ballot 235,143, 235,147,Early Ballot 235,148,Early Ballot 235,170,Early Ballot 235,170,Early Ballot 235,170,Early Ballot 235,147,Early Ballot 235,147,Early Ballot $ cat testfile.txt |awk -F, {'print $2'} |grep -c 170 Jim March wrote: Guys, I have an

Re: Got a text formatting/database question (bash it to hell?)

2009-04-14 Thread James Mcphee
awk '$2~/170/ {print}' filename On Tue, Apr 14, 2009 at 6:34 PM, Jim March 1.jim.ma...@gmail.com wrote: Guys, I have an interesting database problem that I think can be solved on the command line in one shot. But I don't know how :(. I have a comma separated values text file. Each line

Re: Got a text formatting/database question (bash it to hell?)

2009-04-14 Thread Jerry Davis
On Tue, 14 Apr 2009 18:34:30 -0700 Jim March 1.jim.ma...@gmail.com wrote: Guys, I have an interesting database problem that I think can be solved on the command line in one shot. But I don't know how :(. I have a comma separated values text file. Each line shows a voter ID number and

Re: Got a text formatting/database question (bash it to hell?)

2009-04-14 Thread Jon M. Hanson
While that is a pretty trivial problem to solve, I don't think you should be asking how to extract data out of something like voter records on a mailing list in an active criminal lawsuit. Has the attorney approved of this method? How do you know the people that reply are giving you the

Re: Got a text formatting/database question (bash it to hell?)

2009-04-14 Thread Eric Shubert
Jim March wrote: Guys, I have an interesting database problem that I think can be solved on the command line in one shot. But I don't know how :(. I have a comma separated values text file. Each line shows a voter ID number and an election ID number they voted in. NOT who they voted