Read a part of text file

I usually work on huge text files which takes long time to read or even cannot read if the data is bigger than million rows. Is there any way that I can read a part of the text file so I can get a sample date from date column to understand the date format?
Thanks in advance :slight_smile:

Create a variable of type StreamReader, and assign it as seen in the answer below. Then you can read lines one by one from the file.

1 Like

Thanks for your answer. But I can’t assign streamreader variable to this code My.Computer.FileSystem.OpenTextFileReader(β€œC:\testfile.txt”). Could you please share a really basic flow as a example.
I would appreciate.

My mistake. I meant to post this one.

That said, here is an example of how to use it to read all lines, but if you need a sample, you can read however many you would like. (11,8 Ko)

Thank you so much Anthony, it worked.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.