Importing txt into an array

[kadghar]

Hi, what i need is to import a txt file or a text box with numeric values, separated by tabs, into an array.

I dont want to do it by searching chr(9) and chr(10) cause this will be slow for a big matix.

I want it to run under VBA 2002 since i need to share it in the office. I've found that is quite fast to copy the text and paste it into an excel worksheet, then asign the range into a Variants Array. This will take less than one second for huge matrixes.

Anyway I don like using the clipboard or using an array of variants when a singles' or a doubles' one would do.

Any suggestion will be apreciated.
Kad

[Killer42]

The Split() function will easily chop up the lines at the tabs, but presumably that will produce a string array, and a 1D one, at that. Not sure how you'd go about getting it into your "matrix", which I assume is 2D.

[kadghar]

The Split() function will easily chop up the lines at the tabs, but presumably that will produce a string array, and a 1D one, at that. Not sure how you'd go about getting it into your "matrix", which I assume is 2D.

Actually it worked great. I used split twice, with chr(10) and then with chr(9). The only problem is that i still have strings, but nothing CDbl couldnt fix, It was something like:

Dim mTemp() As String
Dim mEmi2() as String
mTemp = Split(Controls(k).Text, Chr(10))
For i = LBound(mTemp) To UBound(mTemp)
    ReDim Preserve mEmi2(0 To i)
    mEmi2(i) = Split(mTemp(i), Chr(9))
Next

Thank you very much Killer

[Killer42]

Cool!

Just out of curiosity, what happens if you make mEmi2 Double instead of String? (Probably an error, but it's worth a try.)

[kadghar]

Cool!

Just out of curiosity, what happens if you make mEmi2 Double instead of String? (Probably an error, but it's worth a try.)

Mmm, actually that code didnt work in VBA, i had to change mEmi2 to Variant, i dont know why VBA works different for jagged arrays. You aren't even able to define them with

dim array()()

That's sad, but at least i get rid of the clipboard