Split and seperate string ASP

All,
I have a string, say:   12345*Dave Smith , 4567*Bill Sims , 91234*John Doe

I need to separate the string into numbers and text so it can update two fields

fields 1: "Dave Smith,Bill Sims,John Doe"
 
fields 2 : "12345,4567,91234"

Thanks in Advance.
UpperdeckerAsked:
Who is Participating?
 
G_HConnect With a Mentor Commented:
Hi There,

Try something like this:

arrSections = Split(Input, ",")
for i = 0 to UBound(arrSections)
    arrBits = Split(arrSections(i), "*")
        Field1 = Field1  arrBits(1) & ","
        Field2 = Field2 & arrBits(0) & ","
next

Field1 = Left(Field1, len(Field1)-1)
Field2 = Left(Field2, len(Field2)-1)

GH
0
 
UpperdeckerAuthor Commented:
Yes, yes! Your awesome!

Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.