Access Querry only part of a string

I am trying to build a function in access that would only select the last User Name.  Seperate by a ²

So this
TTRA²TTRA²TTRA
OCRJMR²OCRJMR²GYEYE55

Would return
TTRA
GYEYE55
garyrobbinsAsked:
Who is Participating?
 
MacroShadowCommented:
Right([Columnt Name], Len([Columnt Name]) - InStrRev([Columnt Name], "²"))

Open in new window

0
 
MacroShadowCommented:
Try this:
Function EE(strInput As String) As String
    Dim arr() As String
    arr = Split(strInput, "²")
    EE = arr(UBound(arr))
End Function

Open in new window

0
 
garyrobbinsAuthor Commented:
I am sorry Function might not be the right term.  I need something like whats below not as part of a macro.

Right([Columnt Name],8)

The user names is not always the same length which is what is throwing me off.
0
 
Rey Obrero (Capricorn1)Commented:
try this

mid([Column Name],  InStrRev([Column Name], "²")+1)
0
 
garyrobbinsAuthor Commented:
Perfect!!!! Thank you some much!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.