Thank you, Ballardw. As I've studied the idiosyncrasies of my data, I'd love to get your advice. Basically I have a column of data that includes a person's career history. The jobs are separated by semicolons. Generally, all the jobs have Titles. Some of the Jobs have an Office (or multiple offices) and an Organization (all have an organization). Some have the years of service, contained in parenthesis, some don't have the dates of service. Below is an example of the text that is in the column that I'm trying to distill. Example Text: "United States Army Officer, Office of Strategy, United States Department of the Army (1980-2009); Highly Qualified Expert, United States Department of the Army (2009-2011); Director, U.S. Army Heritage and Education Center, United States Department of the Army, United States Department of Defense; Assistant Chief, Museum Support Center, U.S. Army Center of Military History, United States Department of Defense; Member, Department of Defense Historical Advisory Committee, Office of the Secretary of Defense, United States Department of Defense (2011-2012); Director and Chief of Military History, U.S. Army Center of Military History, Office of the Administrative Assistant to the Secretary, United States Department of the Army (2011-2014); Chair, The Commission, World War I Centennial Commission; Acting Secretary, American Battle Monuments Commission (2017-2018)" Ultimately, I'd like to end up with as close an approximation as possible to the following: Title: United States Army Officer Office 1: Office of Strategy Organization: United States Department of the Army Start Year: 1980 End Year: 2009 Title: Highly Qualified Expert Organization: United States Department of the Army Start Year: 2009 End Year: 2011 Title: Director Office1: U.S. Army Heritage and Education Center Office2: United States Department of the Army Organization: United States Department of Defense Start Year: End Year: I appreciate your guidance!
... View more
