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

Mark_Fleming
New Member

CSV parsing shoudl include correct handlin of quoted fields.

 

ie. 

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

shoudl result in 4 columns.

 

ThreeCool
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.?