On the blog Rebel Without A Mouse, Nyenyec expressed frustration with OpenOffice.org's regular expressions. He was trying to convert numbers like "40.7 MB" to "40,700,000" for further calculation.
Without the new feature, I expect there would be a more tedious solution involving stripping the binary prefixes (MB, KB, and so on) using Find & Replace and then using Calc multiplication formulas.
Backreferences are available now, so simply copy a table (I choose "50 most edited articles") from the web page and paste into Calc. Then, Search for
([0-9]+)\.([0-9]).?MB.* and Replace with
$1$200000 Make sure Regular expressions is checked in the Find & Replace dialog. Then, repeat accordingly for KB, K, and any others.
Did you notice the
.* at the end of the regular expression? That removes a regular space followed by a non-breaking space. Without it, OpenOffice.org treats the values as text instead of numbers and it would cause problems in calculations.