In a string of text I need to find the first occurrence of a $ (there will
only be one $ in each string) and then return the numbers after the dollar
sign until the first space.

Samples:
1.) E-100 Inventory €“ approved $42,000 (bc 9.32)
2.) E-1700 Inventory €“ signage $7,000 September 2006

Results:
42,000
7,000

--
Thanks!

Craig