cancel
Showing results for 
Search instead for 
Did you mean: 

Read lines of text

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

Status: New
Comments
Level: Powered On

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).

Level: Power Up

CSV parsing shoudl include correct handlin of quoted fields.

 

ie. 

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

shoudl result in 4 columns.