[Newbies] Re: What is the simplest way to create a collection from a text file in CSV format?

I ususally do something like this:

(((FileStream readOnlyFileNamed: 'file.csv') contentsOfEntireFile " read and close " findTokens: String crlf) " split into lines " reject: [:e | e isEmpty]) " lose empty lines " collect: [:e | e findTokens: $,] " split into fields "

Regards, Zulq.

Andy Burnett wrote:

I have a small database containing questionnaire responses. The DB can output the responses (mainly descriptive paragraphs) in CSV format. Ideally, I would like to read each of the records into a collection of some kind. I was hoping that there might be a 'fromCSV:' method, but I haven't found one. One approach I had thought about was to edit the text so in order to create a series of array definitions, and then paste that into a workspace. However, that does lack a bit of elegance! So, is there a neat way of doing this?

Cheers AB

---

---

Beginners mailing list Beginners@lists.squeakfoundation.org http://lists.squeakfoundation.org/mailman/listinfo/beginners