Split settings

[KillerBean]

Hello... I have a question about Split function:
I need to split text ("ABCDEFGH") in letters.. and what I have to write in "Delimiter of string"??
for e.g.

Split("ABCDEFGH", "", 1)

isn't working. :(

PS.: Sorry about my english.

[KillerBean]

I found out:

variable.Substring(i, 1)

But now is another problem... How can i add this value to array?
e.g.
my_array(i) = variable.Substring(i, 1)

can I put "i" in array value id?

[TitanHQ]

As far as i know it would have to be my_array(0) = variable.Substring(i, 1) , A number not i

[albertw]

As far as i know it would have to be my_array(0) = variable.Substring(i, 1) , A number not i

hi

suppose your string strValue holds "2,e,f,5,6,h,u"

then

array=split(strValue,",") 2nd argument is delimiter

first item of the array will be array(0), value 2 etc

[Killer42]

I found out:
variable.Substring(i, 1)
But now is another problem... How can i add this value to array?
e.g.
my_array(i) = variable.Substring(i, 1)
can I put "i" in array value id?

What you need to do is write a loop to go through one character at a time. Something along these lines...

S = "ABCDEFGH"
For i = 1 To Len(S)
  my_array(i) = Mid(S, i, 1)
Next

However, this is VB6 code. From the Substring you've used, I suspect you're using VB.Net. They are similar in some ways, different in others. The same sort of logic should apply here though - loop through the characters, placing them into the array elements.

As albertw pointed out, to use Split there has to be some delimiter character in the string, on which to split. Such as spaces between words, or commas netween data fields, etc.

[willakawill]

I found out:

variable.Substring(i, 1)

But now is another problem... How can i add this value to array?
e.g.
my_array(i) = variable.Substring(i, 1)

can I put "i" in array value id?

Hi. Try this;

Dim ar() As String
Dim MyString As String
Dim i As Integer
 
MyString = "ABCDEFGHIJK"
ReDim ar(Len(MyString) - 1)
 
For i = 0 To UBound(ar)
   ar(i) = MyString.Substring(i + 1, 1)
Next i