Hi y'all, I am trying to extract a number stored as a percentage (in most cases) in a string. Not all rows have the information (for example the last row in the list below), and those that have may have different positions in the string for this information. And the sign "%" is missing for some. I would appreciate any suggestions. Thank you in advance. 0.0028 "XXXXX U.S. FUNDING DCP, 08/01/2012 / " 0.140000% "Xxxxxx Health & Educational Facilities Authority, NATL-RE" 0.430000% 0.450% Due 12/06/12 14633 - 0.520% 16438 0.65% 01/26/13 XXXXXX FINANCE LTD (Q21, Q) 0.646852% BANK OF XXXXXXX .12% YCD 0.12% BANK OF XXX XXXXXX XXX CO NY00.090% 08/07/2012 CP BANK OF XXXXXX XXXX XXX LTD (NY BRANCH) 0.52 XX&X CORP Xxxxxxx Xxxxx Xxxxxxxx Ltd./LLC 0.253506% Xxxxxx Dev. Auth. Poll. Cont. Rev., 0.45% Bonds (New England Pwr. Co. Proj.) Series 1999, tender 08/15/2012, CP Mode Xxxxx Xxxxxx Capital Co.;0.501% Xxxxx Xxxxx Xxxxxx, 0.4% X X X X X X X 0.375 12/28/2012 XXXX Xxxxx Xxxxx, A1+/P1 Series, 0.420%, 1/15/2013 XXX XXXX XX XXXXXX XX 2012-8-17 0.0008 XXXXXXX XXXXX XXXXXX XXXX 00.2300 01/14/2013 XXX XXXXXXX CP 0.17% XXXXXXX XXXXXXX CORP. 0.220 In a joint trading account with XXXXX Xxxxx (USA), Inc. at 0.16%, dated 7/31/2012 due 08/01/2012 XXXX BANK-NEW YORK 0.4 XXXXX Finance Corp. 0% XXXXX & XXXXXX XXXXXXXX (THE)00.140% 08/07/2012 CP 144A Xxx Xxxxxx C D 0.500 09/04/2012 REPO XXXXX XXXXX 0.31 08/22/2012 XXXXX XXXXX CORP00.190% 10/10/2012 CP Xxxxxx Xxxx Xxxx 0.300% Var .310% Due 01/24/13 XXXXX XXXX CORP.-0.580 XXX XXX XXX CO 98137RH29 DCP 08/02/2012
... View more