Share Page

Reading from a file and only using certain lines

ReplyThanks 2016/07/09 16:17:10 0 0

I'm trying to read from a .txt file that has about 100,000 lines.

Because I have the developer version, I can use the read file option and insert all this info into a table. However, I would only like to use 1,000 lines and then remove the 1,000 lines used, from the same .txt file I read from.

I would like to do this repeatedly in different instances.

Is there anyway to do this?

Thank you for your time and consideration. :)

2016/07/11 00:14:33
1. Put your txt file into a csv file.
2. Add a Read file, and then read your txt file to a Table variable table 1.
3. Add a Loop command to read the front 1000 lines out, and then save them to a Table variable table 2, also delete them from table 1.
4. Write the value from table 1 to overwrite the original content in the csv file.
You can edit some steps according to your needs.
<< < 1> >>
Advanced Option