Split field data?
I have a field that has data that would be more useful if split into other fields. For example:
JuniorHigh Fort Worth
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 ;)