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 vo

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 cor

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

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

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 inter

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, j