Read Lines From File

smithmrk

Member
So I want to read the lines from a file and place them into a Collection, but I'm confused on the "End Line" Input...why do I need to put a number?
I want it to read the entire file until it gets to the end.

I currently have Start Line = 0 and End Line = 9999999999
But I'm confused as to why I need a number at all, and is there a way to set it up so it will just read to the end of the file?

Thanks,
Mark
 

VJR

Well-Known Member
Yes it is strange that an End Line argument needs to be provided without any ready made function or action available.
i. Either you can continue with what you have already setup

ii. Or Use the 'LoadTextFile' function in the Calc stage which will load the entire content into a Text data item and then use 'Spit lines' action to get those lines into a collection and then loop through each line (row) in the collection

iii. Or Use 'Read All Text from File' action to get the entire file into a Text data item, use 'Spit lines' action and then loop through each line (row) in the collection
Yes it still needs to be determined whether these in-built actions and the collection will take a very large file.
 
Top