String Formula

[kpreda]

I have a string that holds the city, state and zip. I am trying to obtain just the state from this string. I can't use the mid formula because sometimes the zip code has the 4 digit extension. Is there anyother way for me to extract the state from this string?

 

[Turkbear]

Hi,
Are those sub-parts separated by any other character?





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

 

[kpreda]

No. It's City, (space) State (space) Zip.

 

[lbass]

Try:

split({table.address}," ")[2]

-LB

 

[kpreda]

Thank you so much.

 

[Turkbear]

Hi,
Just for future reference, <space> is a character in a string.






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