AnsweredAssumed Answered

Split field data?

Question asked by TXCiclista on Sep 2, 2011
Latest reply on Sep 6, 2011 by philmodjunk


Split field data?


I have a field that has data that would be more useful if split into other fields. For example:


HighSchool Everman
JuniorHigh Fort Worth
MiddleSchool Burleson

and so on. The first word is the type and is almost always a single word. The second is a location and can be one or more words. I would like a "Type" field and a "Location" field.

Also, there are some fields with only the type, and no location (e.g. "CentralAdministration"). I would assume these won't throw things off, I'll just have a blank in the location field.

I don't seem to be smart enough to figure this out on my own ;)