Hi Joe, I haven't tried it but I would probably start with Avi's CSV Parser http://www.squeaksource.com/CSV.html
But in general you want to parse all of your lines, then for each line parse quoted values, then you can parse commas. All the best, Ron Teitelbaum > -----Original Message----- > From: beginners-boun...@lists.squeakfoundation.org [mailto:beginners- > boun...@lists.squeakfoundation.org] On Behalf Of Joseph Alotta > Sent: Friday, June 17, 2016 4:42 PM > To: beginners@lists.squeakfoundation.org > Subject: [Newbies] CSV file help > > Greetings, > > I am needing conceptual help with parsing these troublesome CSV files. I > was breaking the lines using String >> findToken: > but I found lines where extra deliminators were added. Notice the three > following lines, the first and third line have extra commas from Oak Brook, IL > and the second line does not have the comma. > > > 02/04/2016 Thu,,"COSTCO WHSE #0388 000000000990388 - OAK BROOK, > IL",,,,,37.00,,,,,,,, > 02/05/2016 Fri,,"ELECTRONIC PAYMENT RECEIVED-THANK",,,,,-443.52,,,,,,,, > 02/06/2016 Sat,,"COSTCO WHSE #1088 000000000991088 - BOLINGBROOK, > IL",,,,,50.86,,,,,,,, > > I think I need to parse with the double quotes in mind, but I don’t know > where to break it. > > Also, I was reading in the squeak pages that someone had already written > code for this, but I couldn’t find anything. > > http://wiki.squeak.org/squeak/3260 has two methods, CSVSubstrings and > SequenceableCollection-asCSVLine.st > > Does anyone know where these are now? > > Sincerely, > > Joe. > > > > _______________________________________________ > Beginners mailing list > Beginners@lists.squeakfoundation.org > http://lists.squeakfoundation.org/mailman/listinfo/beginners _______________________________________________ Beginners mailing list Beginners@lists.squeakfoundation.org http://lists.squeakfoundation.org/mailman/listinfo/beginners