AnsweredAssumed Answered

Help with Text Function

Question asked by john.s on Jun 3, 2014
Latest reply on Jun 4, 2014 by raybaudi


Help with Text Function



     I received a file from a school that contains the City, State and Zip all in one field.  I need to break it into three fields.  I  can get the Zip using Right function…all zips are 5 digits...and State using a combination of Middle and Right but can not figure out how to pull the City. I need to pull all characters from the left up to the comma as the City.

     Data looks like this:

     New Haven, CT 06123

     Durham, CT 06321

     Monroe, NY 10950

     any help will be greatly appreciated.