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 <br> with a comma (could also do a series of finds and replaces to replace each <br> 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.
