How to parse the data in python

[sandy]

Hi ,
I have very subjected data in one column . here goes the sample data

Output:
PURCHASE                                AUTHORIZED ON   09/28 UA UNION SQUARE 14        NEW YORK  NY  S388272071655085   CARD 0057
PURCHASE                                AUTHORIZED ON   09/28 7-ELEVEN 18594            ARVADA  CO  S588272206422481   CARD 7621
PURCHASE                                AUTHORIZED ON   09/30 JCPENNEY 1330             CORPUS CHRIST TX  S468273721740671   CARD 8143

from that string I need only specific names.

Ex:for first string I need union square
2nd string I need 7-Elven
3rd string I need JCPenncy.

In sql I can use case statement on that column
by using like operators ex: %Union Square%' ,%7-Elven%',%JCPenncy.%'

so output should be
Union square
7-Elven
JCPENNY...

Only merchants names I need and want to remove unwanted data.
Like that I have 800 rows with different merchants names

ex:as show below..

Output:
RECURRING PAYMENT                       AUTHORIZED ON   09/30 Netflix.com               netflix.com  CA  S308273592350001   CARD 9296
RECURRING PAYMENT                       AUTHORIZED ON   09/30 GOOGLE *YouTube Pr        855-836-3987  CA  S588274040027644   CARD 8785
RECURRING PAYMENT                       AUTHORIZED ON   09/30 GEICO  *AUTO              800-841-3000  DC  S388273506944188   CARD 7336
RECURRING PAYMENT                       AUTHORIZED ON   09/30 FARMERS INS BILLIN        877-327-6392  CA  S308273417047853   CARD 1421

I want to implement in python .Please can any one help in code .thank in advance .