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
Frequent Visitor

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

New Member

CSV parsing shoudl include correct handlin of quoted fields.

 

ie. 

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

shoudl result in 4 columns.

 

Frequent Visitor

Hi,

 

I have the same question.My file is in one drive and I use get file content and store it in a string.Kindly tell me how to loop through each line of the text file.?