Awesome! That is exactly the result I was looking for.
I really appreciate the help. Thank you very, very much!!
-Terry
Who are you replying to?
Sorry Jason, I got confused with the responses... Steve got the exact result I needed. Your result did not get the example data where 'SITE_ID to (' appears as the only set of parenthesis on a row. Your script will work for another data set that I am trying to parse. I really appreciate you taking the time to respond! So glad I decided to join this forum.
Best regards,
-Terry
No worries. I read right over that part and got focused on "between 2nd set of parens"... You'll do well w/ Steve's solution.