Here's one thought: Why not create a hash of arrays? Each hash key would be a column name, and each record would be spread across the arrays using the same array index. If you really wanted to get fancy you could create a hash of cached results to speed up future queries. I wouldn't recommend it over using an RDBMS or even Excel, but as an exercise it can be done.
As a side note, all religious convictions about Open Source aside, using DBI and Access would be a decent solution to a problem like this, since it sounds like you already own it. If you wanted to use Linux exclusively, though there are plenty of other options available to you, like MySQL. -----Original Message----- From: Ralph H. Stoos Jr. [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 21, 2006 9:34 PM To: beginners@perl.org Subject: Another (hopefully more clear) plea for help with CSV data All, I have been asked to do something in Access or Excel which I find disagreeable. Open Source is the way to go and also, PERL is more flexible. I might even obtain a little professional development on this. My last post seemed to confuse folks (thanks to all who responded). I will try to clarify. Machine,PurgeSuccess,PurgePrepared,PurgeStarted,PurgeCauseFaultID,PurgeM odId,PurgeStopModId,ModIdJobCfg,NameJobCfg,Full_cfg,FinisherCfg,plex,PPM ,PropID,AtreeNodeID,JobID,MediaID,Width,Height,Color,Weight,Caliper,Dril led,Finish,Grain,CoatingFront,CoatingBack,SW,additional_info,debuglog 1125785731,N,Y,Y,927,6,5,_2_3_4_5_6,_SFM20_IOT7_SFM7_BFM20_BFM2,_SFM20_I OT7_SFM7_BFM20_BFM2,DUAL_BFM,Simplex,120,44366,1228,392,527,279400,43180 0,white,75,104,FALSE,regular,y,none,none,RV0.6.5.27,,DebugMsgLog.2006_05 _24.07_48_00 1125785731,Y,Y,N,1003,6,,_2_3_4_5_6,_SFM20_IOT7_SFM7_BFM20_BFM2,_SFM20_I OT7_SFM7_BFM20_BFM2,DUAL_BFM,Duplex,120,69206,75,408,29,279400,431800,wh ite,75,104,FALSE,regular,y,none,none,RV0.6.5.27,,DebugMsgLog.2006_05_31. 14_33_25A <snip>long explanation of searchable records problem</snip> -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] <http://learn.perl.org/> <http://learn.perl.org/first-response>
