I’m looking for an efficient way to change state abbreviations to the full name.
I know it can be done with if statements or a case situation, but that would be huge memory usage.
Is there a function possibly that is existing or can it be added if not available?
Thanks
Gopack2
Sure robin.
I have a piston that is using google maps api to find a location via gps coordinates. When it finishes running it gives me a variable filled with information, including state
Here is the piston.
Ok, was trying to avoid a huge amount of those for each state.
Was hoping for a custom function.
Something like this:
Variable states = “AL”;”Alaska”, “AR”:”Arkansas “
Function({States},”AL”)
Would return Alaska
You can do it in one long replace expression.
replace(message, ‘IL’, ‘Illinois’, ‘AL’, ‘Alaska’, ‘AR’, ‘Arkansas’)
Hmm.
This looks interesting.
Would it be possible for you to post the code so that I can import this and have a play. If you don’t mind of course.
Once you’ve typed the full expression with all states, please share so others don’t need to do the hard work as well 
Just an extra thought, and I’m not 100% if this will be a problem or not… but it’s possible that the replace function might change words containing the abbreviations unintentionally, such as changing the word ‘are’ to ‘Arkansase’
Might be worth doing a few tests before you spend time typing out the whole lot!
If it does cause a problem, maybe replace the leading and trailing spaces as well:
replace(message, ‘ IL ’, ‘ Illinois ’, ‘ AL ’, ‘ Alaska ’, ‘ AR ’, ‘ Arkansas ’)
One more approach, you can try a nested ternary… (short list below)
(sC == “AL” ? “ALABAMA” :
(sC == “AK” ? “ALASKA” :
(sC == “AZ” ? “ARIZONA” :
(sC == “AR” ? “ARKANSAS” :
(sC == “CA” ? “CALIFORNIA” :
(sC == “CO” ? “COLORADO” :
(sC == “WY” ? “WYOMING”)))))))
What’s ‘sC’?
The message string contains more than just the abbreviated state, so I don’t see how a ternary operator could pick out the correct part to work on?
this should return the long form of state:
define string shortState = 'AL,AK,AZ,...'
define string longState = 'Alabama,Alaska,Arizona,...'
arrayItem(indexOf(shortState, lookupState), longState)
Oh, I was feeding it the state code == sC
And there’s @bangali’s method, Lists which I have not learned very well yet 
before trying that one please check if indexof supports comma delimited string
this does not actually use lists just comma delimited strings
