Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Stripping a String to Extract a Value within

Status
Not open for further replies.

ftpdoo

Programmer
Aug 9, 2001
202
GB
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
 
Got it fixed!! :eek:) If anybodies interested the solution is:

strSeqNo = Right$(strSeqNo, Len(strSeqNo) - 3)

Jonathan
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top