Link to home
Create AccountLog 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
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of PeterBaileyUk
PeterBaileyUk

ASKER

thx