hello guys,
i’m working with a huge database. and i have to “cut out” certain information, for example, i have this in a mysql table:
1,019,387 (France) (18 January 2000)
1,038,108 (Germany) (31 August 2000)
157,110 (Netherlands) (31 December 2000)
123,038 (Netherlands) (31 December 1999)
158,537 (Netherlands)
744,620 (Spain)
55,145 (Sweden) (30 December 1999)
USD 63,000,000
Twentieth Century Fox Film Corporation, Monarchy Enterprises B.V. and Regency Entertainment (USA), Inc.
and now i want only “USD 63,000,000” and nothing of the rest.
i tried to say take everything with space befor and behind…
but i didn’t get behind the right code of regexpr yet