A calc to strip a portion of text in a field?
I have imported data that is created by another system that adds a city code onto the end of an address. It's a 3 letter code that always starts with a "-" tagged on the street address. Is there a way to strip that off? I was trying to use the FilterText Calculation but am not sure the verbage to get what I am after. Maybe I'm using the wrong calculation too. Any ideas?