06-10-2010, 05:58 PM
Parsing the string should help -
Code:
Str = "test request for fixes; test; ADID=XXX4XXX . Default Password=XXX-XXXXXXX"
nStart = instr(str,"ADID=")+5
nUpto = Instr(nStart,str," ")- nStart
Userid = mid(str, nStart,nUpto)
msgbox Userid