Programming Forums > Application Development > Visual Basic

chepfaust · Apr 6th, 2005, 2:50 PM

For x = 0 To 4
    Let SubArray = Split(GenericTextBox(x).Text, vbCrLf)
    Let MainArray(x) = SubArray()
Next x

i have five text boxes in a control array (generictextbox) and each textbox contains a lot of individual lines of text, formatted like

apples
bananas
carrots
rutebaga

so i'm trying to use the split function using a line break as the delimiter to break down all the entries and store each line into an array (subarray) so i can store that whole array into a parent array (mainarray). every time i execute this code though i get an 'error 13: type mismatch.' the bolded text is highlighted.

subarray and mainarray have both been declared as variant arrays.

any ideas?

thanks

Rory · Apr 6th, 2005, 4:29 PM

Right, for starters you haven't had to use "Let" since GWBASIC. Also Make sure that SubArray is declared as an array of strings, as that is what split returns. Generally, nesting arrays doesn't seem to be a good idea with VB, as you lose the security of typecasting for starters: using double index notation MyArray(x,y) As String would work and wouldn't need to be defined as a variant.

Another consideration is that you can't assign to arrays that already contain data: you would need to somehow "destroy" the array (i.e. set it back to its previous undimmed state before calling redim) but this doesn't seem to be possible!

chepfaust · Apr 6th, 2005, 11:55 PM

thanks for the pointers, i did get the function working but then i revised my entire process to not even deal with parent/sub arrays. it still works, and i'm still grateful to you

Apr 6th, 2005, 2:50 PM	#1
chepfaust Programmer Join Date: Feb 2005 Posts: 62 Rep Power: 4	split() function error - type mismatch (Toggle Plain Text) For x = 0 To 4 Let SubArray = Split(GenericTextBox(x).Text, vbCrLf) Let MainArray(x) = SubArray() Next x For x = 0 To 4 Let SubArray = Split(GenericTextBox(x).Text, vbCrLf) Let MainArray(x) = SubArray() Next x i have five text boxes in a control array (generictextbox) and each textbox contains a lot of individual lines of text, formatted like apples bananas carrots rutebaga so i'm trying to use the split function using a line break as the delimiter to break down all the entries and store each line into an array (subarray) so i can store that whole array into a parent array (mainarray). every time i execute this code though i get an 'error 13: type mismatch.' the bolded text is highlighted. subarray and mainarray have both been declared as variant arrays. any ideas? thanks Last edited by chepfaust; Apr 6th, 2005 at 2:52 PM.

Apr 6th, 2005, 4:29 PM	#2
Rory Expert Programmer Join Date: Jan 2005 Location: London Posts: 542 Rep Power: 4	Right, for starters you haven't had to use "Let" since GWBASIC. Also Make sure that SubArray is declared as an array of strings, as that is what split returns. Generally, nesting arrays doesn't seem to be a good idea with VB, as you lose the security of typecasting for starters: using double index notation MyArray(x,y) As String would work and wouldn't need to be defined as a variant. Another consideration is that you can't assign to arrays that already contain data: you would need to somehow "destroy" the array (i.e. set it back to its previous undimmed state before calling redim) but this doesn't seem to be possible! Last edited by Rory; Apr 6th, 2005 at 4:36 PM.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 6th, 2005, 11:55 PM	#3
chepfaust Programmer Join Date: Feb 2005 Posts: 62 Rep Power: 4	thanks for the pointers, i did get the function working but then i revised my entire process to not even deal with parent/sub arrays. it still works, and i'm still grateful to you

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Programming Forums > Application Development > Visual Basic

split() function error - type mismatch