string manipulation

Sheraz Khan · August 28th, 2009, 06:07 AM

Hi i am trying to write a function that gets the bumeric number out of a string but sonno how to o this.

E.g the string can be :

temp = "CID_19=Y"
temp = "CID_17=Y"
temp = "CID_199=Y"
temp = "CID_1219=Y"

What i have done so far is: (the problem i m facing is to get length the length which i hardcoded to 2 below.

ClientID = mid(temp,(InStr(temp,"_")+1),2)

so the ClientID should contain 19 or 17 or 199 or 1219

cheers

om_prakash · August 28th, 2009, 07:41 AM

If the pattern (CID_NUMBER=Y) is same then you can use something like:

Code:

temp = "CID_19=Y"
temp = "CID_17=Y"
temp = "CID_199=Y"
temp = "CID_1219=Y"
ClientID = replace(replace(temp,"CID_",""),"=Y","")
Response.Write ClientID