[Newbies] Re: CSV file help

[Chris]

Use this one for parsing:

MCHttpRepository 
    location: 'http://www.squeaksource.com/CSV'
    user: '' 
    password: ‘'

Sent from my iPhone

> On Jun 17, 2016, at 3:35 PM, Joseph Alotta <joseph.alotta at gmail.com> wrote:
> 
> So which package should I use to parse CSV data? 
> 
> 
> 
> > On Jun 17, 2016, at 5:05 PM, cbc [via Smalltalk] <[hidden email]> wrote: 
> > 
> > Hi Joseph, 
> > these methods are now in the package located at: 
> > MCHttpRepository 
> >     location: 'http://www.squeaksource.com/CSVData'
> >     user: '' 
> >     password: '' 
> > (follow Ron's excellent advice on how to use this). 
> > 
> > That said, I would no longer use this package to parse CSV - I've recently switched over to Avi's parser as well. 
> > (My package still has some interesting uses for the data once you pull it in.  Of course, it isn't documented.) 
> > 
> > I should clean up the page that you found - I had forgotten that it even existed! 
> > 
> > On Fri, Jun 17, 2016 at 1:42 PM, Joseph Alotta <[hidden email]> wrote: 
> > 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 
> > [hidden email] 
> > http://lists.squeakfoundation.org/mailman/listinfo/beginners
> > 
> > 
> > _______________________________________________ 
> > Beginners mailing list 
> > [hidden email] 
> > http://lists.squeakfoundation.org/mailman/listinfo/beginners
> > 
> > 
> > If you reply to this email, your message will be added to the discussion below: 
> > http://forum.world.st/CSV-file-help-tp4901546p4901574.html
> > To start a new topic under Squeak - Beginners, email [hidden email] 
> > To unsubscribe from Squeak - Beginners, click here. 
> > NAML
> 
> 
> View this message in context: Re: CSV file help
> Sent from the Squeak - Beginners mailing list archive at Nabble.com.
> _______________________________________________
> Beginners mailing list
> Beginners at lists.squeakfoundation.org
> http://lists.squeakfoundation.org/mailman/listinfo/beginners
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.squeakfoundation.org/pipermail/beginners/attachments/20160617/07b54e6e/attachment.htm