Best Way to Show the last 2 characters of a field

[socalshpr]

Hello and Welcome to the world of ERP where there is no state code. The State is always embedded in a address line with the City.

The pattern is City, State eg Anaheim, CA

How do I only get the State to show up

Thanks!

 

[Turkbear]

Create a formula like:

@State
Right({Addressline,2})

To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[senweb]

for clear understanding, i am assigning your address line to a variable x

x = "Anaheim, CA"
x = Mid(x, InStr(x, ",") + 1, Len(x))

output of x = " CA"

regards,
thiru(dot)in(at)gmail(dot)com

 

[fisheromacse]

+1 turkbear.

if there is the possibility of trailing spaces after the state initials, add TRIM, like this:
Right(TRIM({Table.Addressline}),2)

 

[Turkbear]

Hi,
Nice addition fisheromacse ,
I was wondering if I should have done that...





To Paraphrase:"The Help you get is proportional to the Help you give.."