Split variable if contains comma 1

[axLW]

I have a variable which may or may not contain a , (comma).

If it does contain a comma it will always be in the centre of the two parts (without spaces)

I would like to do the following:

If Variable contains "," Then
Split variable into two parts
Before comma is NewVar1
After comma is NewVar2
End if

so if the starting value is

W1,Mayfair

I would want this split into two new variables

W1 and Mayfair

 

[xwb]

Do you want to do this in VBScript

http://www.w3schools.com/vbscript/func_split.asp

or Javascript

http://www.w3schools.com/jsref/jsref_split.asp

Basically the operation is the same: it puts the result into an array. You then have to assign newvar1 to the 0th element and newvar2 to the 1st element.

 

[axLW]

Great link there. Thanks a lot. I should be able to get that working quite easily.

 

[axLW]

In this example pickup = W1,Mayfair

If instr(pickup,",") Then

a = Split(pickup)
a(0) = Var1
[b]a(1) = Var2[/b]

End If

Microsoft VBScript runtime error '800a0009'

Subscript out of range: '[number: 1]'

/quote.asp, line 12

Is there an obvious error here?

 

[guitarzan]

a = Split(pickup, [highlight #FCE94F]","[/highlight])

 

[guitarzan]

And .... If you still want to assign the values to two other variables, it would be
[tt]Var1 = a(0)
Var2 = a(1)[/tt]

 

[axLW]

Thank you. It's working now.

 

[MakeItSo]

@axLW

Thank you. It's working now.

In that case it is always good practice to click on that little link on the bottom right of the helpful post that answered your question; the link named "Great post? Star it!".
That way others can more easily identify threads that probably have an answer.
;-)


"Knowledge is power. Information is liberating. Education is the premise of progress, in every society, in every family." (Kofi Annan)
Oppose SOPA, PIPA, ACTA; measures to curb freedom of information under whatever name whatsoever.

 

[axLW]

Noted