Hi,
I've got a string strMyString which will contain values such as:
seq1
seq78
seq129
All i want to do is to strip away the sequence "seq" part of the string to simply leave the number remaining..
I'm currently doing this:
strSeqNo = Right(strSeqNo, InStr(strSeqNo, "e")
But it doesn't work when the number part is three digits..
Any help would be great,
Thankx,
Jonathan
I've got a string strMyString which will contain values such as:
seq1
seq78
seq129
All i want to do is to strip away the sequence "seq" part of the string to simply leave the number remaining..
I'm currently doing this:
strSeqNo = Right(strSeqNo, InStr(strSeqNo, "e")
But it doesn't work when the number part is three digits..
Any help would be great,
Thankx,
Jonathan