Find Numbers Filter
What is it?
The Find Numbers filter works by converting your output to a table and discarding all non-numeric data. This can be very useful when the data you need may be embedded in a block of text but only the values are needed.
How is it used?
Add Filter > More Filters… > Find Numbers
The Find Numbers filter comes with a number of options. The first mode settings are “Automatic” or “Custom”, the automatic mode words to find all numbers regardless of range. The second mode “Custom” works to extract all numbers, however, a range can be specified and whether to focus on only integer (whole) numbers or float (decimal) numbers.
For both modes, the output can be specified in either the original value or a formatted variant that converts the values to decimals.