Link to home
Start Free TrialLog in
Avatar of PeterBaileyUk
PeterBaileyUk

asked on

either side of specific chr in vba

if i have this :
 "M4R711/M4R713"
 "M4R711/M4R713/M4R713"
I would like to extract the strings divided by the slash and put in an array but not sure how could be any number of slashes my upper limit above in example strings is 3

so above would be :
arrel (0): "M4R711" arrel (1) "M4R713"

am in access 2007 vba
ASKER CERTIFIED SOLUTION
Avatar of Chris Millard
Chris Millard
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 PeterBaileyUk
PeterBaileyUk

ASKER

thx