Help with extracting data from multi-line text in attribute table
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.
Unfortunately this is the same dataset. In the 1st screen shot, I need the record replicated 4x and fields for name and date created, so the same coordinate is associated with each name. In the second screen shot I need additional fields created for the record. Ultimately, the final schema will have all the fields are mentioned the different records. The final dataset have a unique record for each person or unknown and contain all the data fields. In many cases the values in the field will be blank, because there is no data available. Here is an excel mockup
