Separate Field Contents On One Layout To Another Layout Creating A New Record For Each
I have a field (Surnames) in a record on Layout 1, which can contain any number of words, there is no limit considering that the information in this field is imported from another source via excel. I need to separate each name into a new record on Layout 2.
Usually, but not always, included after each name there is a location. Ideally I would like to separate the location into a “Location” field on the same new record with the corresponding “Surname,” which is in its own field.
Following are three different formats that I have imported and there could be other formatting variations separated by commas or other punctuations:
1st formatting scenario:
Mason (VA / KY) / Renick (WV / KS / KY) / Lewis (VA) / Cochran (KY) / Scott (KY / VA) / Walker (VA / PA / Scotland) / Rutherford (VA / PA / Scotland)
2nd formatting scenario:
Neal / Thomas / Gill / Jordan / Brown/ Sr / Fry / Pierson / Waters
3rd formatting scenario:
Thompson (Alabama) / Walpole (Louisiana) / Taylor (Louisiana) / Moore (Arkansas) / Wren (Louisiana) / Lindsay (Louisiana) / Purifoy (Alabama) / Wood (Alabama) / Stallings / Cook (Arkansas)