AnsweredAssumed Answered

Help with extracting data from multi-line text in attribute table

Question asked by DawnMcCall on Oct 8, 2019
Latest reply on Oct 8, 2019 by DawnMcCall

Any chance anyone knows a way to reverse engineer the multi-lines text in a single record of an attribute table into multiple features with multiple fields?.  It looks like they are trying to do a many to one relationship by listing many records and dates (sometimes other attributes) in a single attribute value of "comments."  I am trying to extract each record and all the different fields. It is almost like they embedded a pivot table.  The added complication is that in the same "comments" field they also have single record data with many different fields and the UniqueID is not in the comment field.  This started as a shapefile and is not a file geodatabase.  The original data creation is unknown.

Outcomes