InStr Question (Access97/00)

Topic

New Reply

I have some strings like:
RA25840*1*G0133813 or
RA29014*10*A0485
I need to extract the last portion of the string after the last *
I’ve used InStr to get rid of one occurance of a character but can’t figure out how to get rid of 2 in one operation.

Reply | Quote

Replies

Would nesting the calls work? something like
result = Instr(1,Instr() etc.)

Reply | Quote

Use :
Mid(“RA25840*1*G0133813”,InstrRev(“RA25840*1*G0133813″,”*”)+1)

Reply | Quote

What is InstrRev?

Reply | Quote

From the help file :
Returns the position of an occurrence of one string within another, from the end of string

Reply | Quote

I just check it out, it’s a new function in Access 2000. If you need code for 97 use this as function :

Function EndOfString(strPased As String) As String
Do While InStr(strPased, "*")  0
    strPased = Mid(str, InStr(strPased, "*") + 1)
Loop
EndOfString = strPased
End Function

Reply | Quote

Francois,
That function worked great. I still found no reference to InstrRev in Access 2000 help file.
Thanks,
Scott

Reply | Quote

You have to look in the help file when you are in VBA.
Help files since Access 2000 are only good to

Reply | Quote