I need to learn a way in which I can normalize data and in the same process duplicate certain records of a point feature class. The issue is as follows. I am provided address data in the following format (a single field):
"1234, 1236, 1238 Travis Blvd" or "1234/ 1236/ 1238 Travis Blvd"
I currently manually select each individual record in this format, and then make a copy (Ctrl V, Control C) into the target layer (same as origin). In the case above, I would make two copies. I then manually edit the address to make each record unique. It is totally fine that the geography for all resulting points is identical. All other fields in the record should be preserved in this process.
Does anyone have a slick idea on how to automate (script) this task?