AnsweredAssumed Answered

Separate Field Contents On One Layout To Another Layout Creating A New Record For Each

Question asked by ezellkendrick on Oct 7, 2014
Latest reply on Oct 9, 2014 by ezellkendrick

Title

Separate Field Contents On One Layout To Another Layout Creating A New Record For Each

Post

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)

 

Please advise.

Outcomes