Rudolf,
<br/><br/>That is perfect! Thank you so much. I love the simple yet elegant solutions.
<br/><br/>I tested it with the large file and it works great. And best of all, it is included in the basic system.
<br/><br/>Sincerely,
<br/><br/>Joe.
<br/><br/><div class='shrinkable-quote'><br/>> On Jun 18, 2016, at 12:25 PM, Rudolf Rednose [via Smalltalk] <<a href="/user/SendEmail.jtp?type=node&node=4901718&i=0" target="_top" rel="nofollow" link="external">[hidden email]</a>> wrote:
<br/>>
<br/>> Hello Joseph, maybe
<br/>> findTokens:',' escapedBy: '"'
<br/>> is sufficient.
<br/>>
<br/>> for example:
<br/>> |data fields|
<br/>> data := OrderedCollection new.
<br/>> data add: '02/04/2016 Thu,,"COSTCO WHSE #0388 000000000990388 - OAK BROOK, IL",,,,,37.00,,,,,,,,' copy.
<br/>> data add: '02/05/2016 Fri,,"ELECTRONIC PAYMENT RECEIVED-THANK",,,,,-443.52,,,,,,,,' copy.
<br/>> data add: '02/06/2016 Sat,,"COSTCO WHSE #1088 000000000991088 - BOLINGBROOK, IL",,,,,50.86,,,,,,,,' copy.
<br/>> data do:[ :item |
<br/>> fields := item findTokens:',' escapedBy: '"'.
<br/>> "show result in Transcript"
<br/>> Transcript cr; show: 'Line: ', item; cr; show: 'Number of Fields:', fields size asString; cr.
<br/>> 1 to: fields size do:[:n| Transcript show:( n asString,' [', (fields at: n),']');cr]
<br/>> ].
<br/>>
<br/>> Line: 02/04/2016 Thu,,"COSTCO WHSE #0388 000000000990388 - OAK BROOK, IL",,,,,37.00,,,,,,,,
<br/>> Number of Fields:16
<br/>> 1 [02/04/2016 Thu]
<br/>> 2 []
<br/>> 3 [COSTCO WHSE #0388 000000000990388 - OAK BROOK, IL]
<br/>> 4 []
<br/>> 5 []
<br/>> 6 []
<br/>> 7 []
<br/>> 8 [37.00]
<br/>> 9 []
<br/>> 10 []
<br/>> 11 []
<br/>> 12 []
<br/>> 13 []
<br/>> 14 []
<br/>> 15 []
<br/>> 16 []
<br/>> Line: 02/05/2016 Fri,,"ELECTRONIC PAYMENT RECEIVED-THANK",,,,,-443.52,,,,,,,,
<br/>> Number of Fields:16
<br/>> 1 [02/05/2016 Fri]
<br/>> 2 []
<br/>> 3 [ELECTRONIC PAYMENT RECEIVED-THANK]
<br/>> 4 []
<br/>> 5 []
<br/>> 6 []
<br/>> 7 []
<br/>> 8 [-443.52]
<br/>> 9 []
<br/>> 10 []
<br/>> 11 []
<br/>> 12 []
<br/>> 13 []
<br/>> 14 []
<br/>> 15 []
<br/>> 16 []
<br/>> Line: 02/06/2016 Sat,,"COSTCO WHSE #1088 000000000991088 - BOLINGBROOK, IL",,,,,50.86,,,,,,,,
<br/>> Number of Fields:16
<br/>> 1 [02/06/2016 Sat]
<br/>> 2 []
<br/>> 3 [COSTCO WHSE #1088 000000000991088 - BOLINGBROOK, IL]
<br/>> 4 []
<br/>> 5 []
<br/>> 6 []
<br/>> 7 []
<br/>> 8 [50.86]
<br/>> 9 []
<br/>> 10 []
<br/>> 11 []
<br/>> 12 []
<br/>> 13 []
<br/>> 14 []
<br/>> 15 []
<br/>> 16 []
<br/>>
<br/>> Sincerely,
<br/>> Rudolf.
<br/>> Gesendet: Freitag, 17. Juni 2016 um 22:42 Uhr
<br/>> Von: "Joseph Alotta" <[hidden email]>
<br/>> An: [hidden email]
<br/>> Betreff: [Newbies] CSV file help
<br/>> Greetings,
<br/>>
<br/>> I am needing conceptual help with parsing these troublesome CSV files. I was breaking the lines using String >> findToken:
<br/>> 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.
<br/>>
<br/>>
<br/>> 02/04/2016 Thu,,"COSTCO WHSE #0388 000000000990388 - OAK BROOK, IL",,,,,37.00,,,,,,,,
<br/>> 02/05/2016 Fri,,"ELECTRONIC PAYMENT RECEIVED-THANK",,,,,-443.52,,,,,,,,
<br/>> 02/06/2016 Sat,,"COSTCO WHSE #1088 000000000991088 - BOLINGBROOK, IL",,,,,50.86,,,,,,,,
<br/>>
<br/>> I think I need to parse with the double quotes in mind, but I don’t know where to break it.
<br/>>
<br/>> Also, I was reading in the squeak pages that someone had already written code for this, but I couldn’t find anything.
<br/>>
<br/>> <a href="http://wiki.squeak.org/squeak/3260" target="_top" rel="nofollow" link="external">http://wiki.squeak.org/squeak/3260</a> has two methods, CSVSubstrings and SequenceableCollection-asCSVLine.st
<br/>>
<br/>> Does anyone know where these are now?
<br/>>
<br/>> Sincerely,
<br/>>
<br/>> Joe.
<br/>>
<br/>>
<br/>>
<br/>> _______________________________________________
<br/>> Beginners mailing list
<br/>> [hidden email]
<br/>> <a href="http://lists.squeakfoundation.org/mailman/listinfo/beginners" target="_top" rel="nofollow" link="external">http://lists.squeakfoundation.org/mailman/listinfo/beginners</a><br/>>
<br/>> _______________________________________________
<br/>> Beginners mailing list
<br/>> [hidden email]
<br/>> <a href="http://lists.squeakfoundation.org/mailman/listinfo/beginners" target="_top" rel="nofollow" link="external">http://lists.squeakfoundation.org/mailman/listinfo/beginners</a><br/>>
<br/>>
<br/>> If you reply to this email, your message will be added to the discussion below:
<br/>> <a href="http://forum.world.st/CSV-file-help-tp4901546p4901691.html" target="_top" rel="nofollow" link="external">http://forum.world.st/CSV-file-help-tp4901546p4901691.html</a><br/>> To start a new topic under Squeak - Beginners, email <a href="/user/SendEmail.jtp?type=node&node=4901718&i=1" target="_top" rel="nofollow" link="external">[hidden email]</a>
<br/>> To unsubscribe from Squeak - Beginners, click here.
<br/>> NAML
</div><br/>
<br/><hr align="left" width="300" />
View this message in context: <a href="http://forum.world.st/CSV-file-help-tp4901546p4901718.html">Re: [Newbies] CSV file help</a><br/>
Sent from the <a href="http://forum.world.st/Squeak-Beginners-f107673.html">Squeak - Beginners mailing list archive</a> at Nabble.com.<br/>