i am trying to split a string until a specific pattern for e.g
below is my string
e.g. 123456 AL0120102090990AL01303030CS01999998888777
i want the above to be split into two
123456 AL0120102090990AL01303030
123456 CS01999998888777
pls help me !
[Edit - just posting the code from OP comment below (and bumping by default - sorry)]
managed to read the string from "123456 AL0120102090990AL01303030" i dont know how to continue further to read the rest , this is the code i am using
dim str, lngDelimiter , strFull as string
str = "AL0120102090990AL01303030CS01999998888777"
lngDelimiter = InStr(1, strFull, "CS01")
If lngDelimiter > 0 Then
'parse out everythig before the delimiter
strSubString = Strings.Left(str, lngDelimiter - 1)
the above will return this
AL0120102090990AL01303030
how to read the rest of the string value?