Extract Attributes from a Field

Question

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.?

Kara_Shindle · Answer

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.

rzufelt · Answer

Similar to @FrancisClergue , but could open the txt file in Excel, replace the
with a colon, then text to columns using the colon as the delimiter. Then just delete the columns you don't want. R

FrancisClergue · Answer

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: * import the .dbf in Access * copy the entire field of values you want to separate from Access and paste into a .txt. file * find and replace
with a comma (could also do a series of finds and replaces to replace each
and the following field name and unnecessary spaces with a comma) * import back into Access as a comma delimited text file, which will put each value into its own field * use the RIGHT() function to to get rid of the field name (like From:) with an update query if you didn't find and replace them out above (could just do this in ArcMap with the same field calculator function) * add all the appropriate fields to the attribute table in ArcMap * export the Access table you made to a .dbf and re-import to ArcMap * join the table with OBJECTID * use field calculator to copy over the separated values from the joined table to each corresponding field you added above to the master attribute table * remove the join Something like that...clunky, but if it's a one-time job it shouldn't take long.