Extract Right words to "-"

[lcook1974]

I have a report that people put a location in as county but labeled like this:

Some type of event - Countyname County

How do I get just the "Countyname County" so I can group on that in a report?


Larry

 

[Brianwarnock]

Use Instr or InstrRev to find the position of the Hyphen and Mid or Right to extract the data.

Brian

 

[vbaInet]

Look into the Split() function or Right() and InStr()

 

[Brianwarnock]

Actually if you use Right you have to look at Len aswell, I prefer the following
assuming that County names do not contain hyphens

Mid(yourfield,InstrRev(yourfield,"-")+2)

Brian

 

[lcook1974]

I'm on it...I'll post some code if it doesn't work.

Thanks vbaInet!

 

[Brianwarnock]

I'm on it...I'll post some code if it doesn't work.

Thanks vbaInet!

Oh guess I'm invisible

Brian

 

[vbaInet]

Actually if you use Right you have to look at Len aswell, I prefer the following
assuming that County names do not contain hyphens

Mid(yourfield,InstrRev(yourfield,"-")+2)

Brian

Oh yes, that's right Brian. I was actually thinking of Mid()

Oh guess I'm invisible

You shouldn't have retired so early

 

[lcook1974]

My Bad Brian...you are not invisible! I apologize!

Thank you to you both!!