Please see the attached image. Each of the underlined section of the string needs to go to its respective field.
Currently all the information is within one field. What's the best way to extract information I need and place it in their respective fields.?
I'd be inclined to export the attribute table to a .dbf and try to separate the values in MS Access. Doing a little testing, you'd:
Something like that...clunky, but if it's a one-time job it shouldn't take long.
I could also see you doing a lot of this with Python and string slicing or even using Pandas dataframes. Lots of methods depending on your comfort zone.
I also think this could probably be accomplished with a combination of Arcade and Field Calculator.