I think that will give just about any CSV parser some trouble. Quotes in CSV files are used to denote fields that may contain commas. Is there any way to get Radius to use another string delimiter?
-----Original Message----- From: Jason Frisvold [mailto:[EMAIL PROTECTED]] Sent: Friday, June 07, 2002 8:43 AM To: Hanson, Robert; Beginners@Perl. Org (E-mail) Subject: RE: :CSV 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] -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
