Get trailing Characters from String

[jaykappy]

I have the strings below...I want the values to the right of the second _
Note there will be different numbers of characters so a simple Right([field] , 3) wont work



A3_B4_C1
A3_B4_C12
A3_B4_C122

Thoughts....some sort of Mid? Not sure of the syntax

[ItsMe]

I use instrrev for situations like this. A string contains multiple instances of a special character and I want the text after the last instance. Here is an example.

Dim strInternational As String
Dim strYear As String

'assign user input to string variable
strInternational = "28-2-2010 1:20:59 PM"

strYear = Mid(strInternational, InStrRev(strInternational, "-") + 1)
Debug.Print "strYear = " & strYear

[jaykappy]

If I am doing this from a Query Builder would the below work...

I assume I can replace the - with the _ that is needed?



Mid(FieldName, InStrRev(FieldName, "-") + 1)

or

Mid( [FieldName], InStrRev( [FieldName], "-") + 1)

[jaykappy]

YES this worked Perfectly...

Mid( [A_B_C] , InStrRev( [A_B_C] , "_") + 1)

THANK YOU MUCH

[ItsMe]

Did not notice I was in the Queries forum. Glad you got it sorted.