Split string

[imgsimonebiliato]

Hi,
I have this string; 108-306-204..
How can I get:
a = 108
b = 306
c = 204
??

 

[Mahares]

Here it is:

Dim strBeforeSplit As String 
strBeforeSplit="108-306-204"
Dim strSplit() As String
strSplit=Regex.Split("-",strBeforeSplit)
Msgbox(strSplit(0) &  "  " & strSplit(1) &  "  " & strSplit(2),"")   'returns: 108  306  204

 

[imgsimonebiliato]

Here it is:

Dim strBeforeSplit As String 
strBeforeSplit="108-306-204"
Dim strSplit() As String
strSplit=Regex.Split("-",strBeforeSplit)
Msgbox(strSplit(0) &  "  " & strSplit(1) &  "  " & strSplit(2),"")   'returns: 108  306  204

It doesn't help me, because I need each value different time!

 

[Mahares]

That is simple. All you need to do is equate your variables to the different array components like this:
a=strSplit(0)
b=strSplit(1)
c=strSplit(2)

 

[paolofi]

HI,
why this works:

Dim Valore As String
Dim strSplit() As String
   
Value = "6-03/12/2012-test"      '<--------------
   
strSplit=Regex.Split("-",Value )

Msgbox(strSplit(0) &  "  " & strSplit(1) &  "  " & strSplit(2),"")

and this not?

Dim Valore As String
Dim strSplit() As String
   
Value = "6|03/12/2012|test"    '<--------------
   
strSplit=Regex.Split("|",Value )

Msgbox(strSplit(0) &  "  " & strSplit(1) &  "  " & strSplit(2),"")

the "|" symbol is reserved?.

Regards

 

[NJDude]

Yes, the "|" is a metacharacter and it has to be escaped like this: "\|".

 

[paolofi]

Yes, the "|" is a metacharacter and it has to be escaped like this: "\|".

Many thanks NJDude now it works:

strSplit=Regex.Split("\|",Value )