|P is for Practical|
OK, OK, I'm taking the DBI plunge. Now what?by peppiv (Curate)
|on Jan 10, 2002 at 21:23 UTC||Need Help??|
peppiv has asked for the wisdom of the Perl Monks concerning the following question:
I recently posted a question about querying a text file (which amused a few people) and as tilly pointed out I really need to use DBI.
I understand SQL a little, but not how to query a delimited text file.
Here's at least something to start with, but it's still miles away from a working solution. Please help point me in right direction. (I installed DBI and DBD::CSV on my server - Apache/FreeBSD).
Here's the type of file I'm working with (posted again for apparently more amusement)
I have a pipe delimited text file. Looks like this:
Jimmy | yes | | | yes | yes | yes
Robert | yes | yes | | | |
JohnPaul | yes | yes | yes | yes | |
Bonzo | | | yes | yes | yes | |
How can I make a list from multiple field choices?
example - List 1 = those who have "yes" in field #2 but nothing in field #3
List 2 = those who have "yes" in field #2 and field #7
List 3 = "yes" in field #2, nothing in field #3, but yes in field #6
"Thanks for all the fish"