Hi guys. I'm working on an app in which the user copy and pastes from a website into a richtextbox then the program uses the phone number, name and "match by string" from the richtexbox. What is copied is like an Excel table type thing but all the data is in Column "A". The data isn't tab deliminated. If i split on spaces then that will give incorrect results since some of the pieces of data have spaces in them. It looks like I'm about to do some really nasty ugly coding to get to the values I need. Can you guys super please take a look at this snippet of data and tell me of a graceful way of getting the name, phone number and that last value in the line if such coding exists? This is the info I would need to pickup on in the first row of data. SHEKITA LLOYD, (xxx) 956-80, and Non-Payment of premium.

This is a sample of the data:

Producer Code Policy # Insured Name Insured Phone Policy Status
08xx57 350xxx1xxx Cancelled Non-Reinstateable 01/09/2012 Non-Payment of premium;
08xx57 350xxx1xxx SHEKITA LLOYD (xxx) 956-80 Cancelled Non-Reinstateable 11/18/2011 Non-Payment of premium;
08xx57 350xxx2xxx DAVID MORALES (xxx) 993-53 Cancelled Non-Reinstateable 12/03/2011 Non-Payment of premium;
08xx57 350350xxx8 LORRAINE JOHNSON (xxx) 403-86 Cancelled Non-Reinstateable 11/28/2011 Non-Payment of premium;
08xx57 3503505xxx CHRYSTAL YOUNG (xxx) 508-31 Cancelled Non-Reinstateable 02/05/2012 Non-Payment of premium;
08xx57 0704000xxx LARRY MORALES JR (xxx) 239-80 Cancelled Non-Reinstateable 02/29/2012 Substantial Increase in Hazard
08xx57 3503503xxx ASHANTI WILLIAMS (xxx) 634-68 Cancelled-Reinstateable 02/06/2012 03/07/2012 $6.86 Non-Payment of premium;
08xx57 5503007xxx Sergio J Brito xxx-844-8358 Cancelled-Reinstateable 02/09/2012 03/10/2012 $196.68 Non-payment of premium
08xx57 0703702xxx Alex Lopez 323-xxx-1871 Cancelled-Reinstateable 02/10/2012 03/11/2012 $108.00 Non-payment of premium
08xx57 3503501xxx SUN HONG (310) xxx-75 Cancelled-Reinstateable 02/11/2012 03/12/2012 $43.28 Non-Payment of premium;
08xx57 0703600xxx Rogelio Patino 310-xxx-0090 Cancelled-Reinstateable 02/18/2012 03/19/2012 $188.60 Non-payment of premium
08xx57 070370xxxx Jaqwun L Turner 323-xxx-0121 Cancelled-Reinstateable 02/18/2012 03/19/2012 $57.40 Non-payment of premium