Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have field that gives location as such 1234 Unnamed Road, Orlando, FL 12345, USA. All I want is the Orlando, FL part of the location however. Any way to only get City, State in either the load script or text object?
Thanks in advance/
Subfield(YourField,',',2) as City,
Subfield(YourField,',',3) as State,
May be this
SubField(Location, ', ', -3) as City,
SubField(SubField(Location, ', ', -2), ' ', 1) as State
Sample attached
Sunny,
This is what I needed!
Thank you,
Aaron