How to get 10 records at a time in a txt or xlsx list

Help StudioX
, , ,
8

Hi @Rodrigo_Buch ,

So, if I understand correctly, you need help building an algorithm that fits your needs.

Try this:

  • Read the text file
  • Split it into an array using String.Split you may use VbCrLf as the separator
  • Count your items
  • set an int32 variable as your index starting at 0
  • Use a while loop
    • Use another loop from index to index +9
      • Do your actions
    • Increment your index by 10, be careful not to go out of your array bounds