I have this data in my table:
Restaurants, Inc. (BJRI)
Cheesecake Factory in (CAKE)
P.F. Chang's China Bistro (PFCB)
Panera Bread Company (PNRA)
Rubio's Restaurants, Inc. (RUBO)
Abercrombie & Fitch Co. (ANF)
Aeropostale, Inc. (ARO)
I want to select the data which between brackets and put in a new field ,
Like this :
BJRI
CAKE
PFCB
PNRA
RUBO
ANF
ARO
How to do that ?
Restaurants, Inc. (BJRI)
Cheesecake Factory in (CAKE)
P.F. Chang's China Bistro (PFCB)
Panera Bread Company (PNRA)
Rubio's Restaurants, Inc. (RUBO)
Abercrombie & Fitch Co. (ANF)
Aeropostale, Inc. (ARO)
I want to select the data which between brackets and put in a new field ,
Like this :
BJRI
CAKE
PFCB
PNRA
RUBO
ANF
ARO
How to do that ?