Read lines of text

[Mattw112IG]

To me this seems like such a basic request.

I want to be able to read lines of a text file or CSV or anything and then do stuff with that text such as populating a spreadsheet.

Terry

[jrwarwick]

I think a not-too-complex but still pretty flexible way to approach is to have the step/action read in with no delimiter by default, but under advanced, allow specifying a delmiter string (comma by default, but also tabs, pipes, and even a "white space" option to get all the "words", or a limited sequence of characters in case of some weird legacy format).

[Mark_Fleming]

CSV parsing shoudl include correct handlin of quoted fields.

ie. 

"item1", "test item 2, test", item3, "Item4"

shoudl result in 4 columns.