Dynamic Variable in Split function Expression

**BrianAll** · 07-02-2013, 09:59 PM

Hello,

does somebody knows if it is possible to include a dynamic variable in the Split function Expression?
I'll make an example.
I have two strings:
C1 = "A_B_C_D_"
C2 = "1_2_3_4_"

Instead of using twice the Split function like:
myArray1 = Split(C1, "_")
myArray2 = Split(C2, "_")

I would like to create a loop like:
For j = 1 to 2
For i = 1 to 4
myString = "C" & j
myArray(j, i) = Split(myString, "_")
Next

This would allow me to fill a bidimensional array within a loop.

I've tried to do it as simply shown in the example but the Split function read C1 as a string instead of reading its value (C1 = "A_B_C_D_").

Thank you

**AB33** · 07-03-2013, 04:28 AM

Brian,
Please use code tags as per forum's rule.
Yes you can. All you need to is to loop through either the range or an array.
The first code, loops through 4 columns for each row and display the split result in to next empty row in column C. The second code first loads the data in to array and loop through the array and load back the range in to array. This is not complete code, just to give a headway.

Please Login or Register  to view this content.

**jindon** · 07-03-2013, 04:40 AM

Please Login or Register  to view this content.

**JosephP** · 07-03-2013, 05:19 AM

for instance

Please Login or Register  to view this content.

**BrianAll** · 07-03-2013, 06:51 AM

Hello,

since I don't have to deal with Ranges but only with strings and arrays, the last solution was the most appropriate.
Joseph, it's exactly what I was searching for.

Thank you all