Ugh... I figured out what it's choking on by using Text::CSV instead of DBD::CSV ... Some of the entries look something like this :
"06/06/02","22:16:23","Some stuff here","LDAP JUNK DN="\\HERE\123" AT="7" US="" SI="12345"",,,,"More junk",,, The problem, I believe, is that LDAP JUNK.... I think those quotes inside the quotes area are causing Text::CSV to fail that line... The lines in the file without the LDAP garbage are working fine... Anyone know anything about Text::CSV? Is there a way around this? --------------------------- Jason H. Frisvold Senior ATM Engineer Engineering Dept. Penteledata CCNA Certified - CSCO10151622 [EMAIL PROTECTED] --------------------------- "Imagination is more important than knowledge. Knowledge is limited. Imagination encircles the world." -- Albert Einstein [1879-1955] -----Original Message----- From: Hanson, Robert [mailto:[EMAIL PROTECTED]] Sent: Friday, June 07, 2002 10:00 AM To: Jason Frisvold; Beginners@Perl. Org (E-mail) Subject: RE: :CSV As an alternative you could use Text::CSV to split the fields. Rob -----Original Message----- From: Jason Frisvold [mailto:[EMAIL PROTECTED]] Sent: Friday, June 07, 2002 9:36 AM To: Beginners@Perl. Org (E-mail) Subject: DBD::CSV Is anyone here familiar with DBD::CSV? I seem to be hitting a limit (I think) but I'm not sure how to figure it out... I have a CSV file with about 114 columns in it (I'm not generating these myself, it's Steel Belted Radius doing it) and I want to use DBD::CSV to pull the fields I want and place them into a mySQL database. I think I'm hitting a max column limit, but I'm not sure because I can't seem to find it in the docs... I'm afraid to parse it by hand because I'm afraid that if I use a simple split(/,/, $_) that I'll wind up splitting something that shouldn't be split... Anyone have any clue as to if there is a limit with DBD::CSV here? Or am I going to have to spend the time to build the robust parser I need? Thanks, --------------------------- Jason H. Frisvold Senior ATM Engineer Engineering Dept. Penteledata CCNA Certified - CSCO10151622 [EMAIL PROTECTED] --------------------------- "I love deadlines. I especially like the whooshing sound they make as they go flying by." -- Douglas Adams [1952-2001] -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
