Separate text to columns, delimited by commas

[ronaldovuiv]

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/

[m_woolf]

Subfield(YourField,',',2) as City,

Subfield(YourField,',',3) as State,

[sunny_talwar]

May be this

SubField(Location, ', ', -3) as City,

SubField(SubField(Location, ', ', -2), ' ', 1) as State

[sunny_talwar]

Sample attached

[ronaldovuiv]

Sunny,

This is what I needed!

Thank you,

Aaron