Link to home
Start Free TrialLog in
Avatar of Upperdecker
Upperdecker

asked on

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.
ASKER CERTIFIED SOLUTION
Avatar of G_H
G_H
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Upperdecker
Upperdecker

ASKER

Yes, yes! Your awesome!

Thanks