file.txt split

[gimelie]

hi,

I'm trying to split my file into arrays with a "," delimiter.

however, when it's showing in the listbox, the only data that appears is the last data row in the file and it is repeated 3 times.

my data looks like the following:
1,blue,111,1000
2,green,222,2000
3,yellow,333,3000
4,red,444,4000
5,black,555,5000
6,beige,666,6000

and this is the code:

Please Login or Register  to view this content.

Thank you for your help

[Firefly2012]

Hi

That isn't all your code - you need to show how you populate your InputData variable and any loop you use for that.

[gimelie]

hi,

this is all my code:

Please Login or Register  to view this content.

[Firefly2012]

You don't need the For Next, but you do need to modify i on each iteration of the Do Loop - amend the For Next to:

Please Login or Register  to view this content.

[gimelie]

cool, thank u! :D