Free tool

Extract numbers from text

Extract numbers from text: take the first number in each line (or every number), with decimals and minus signs. 1,299 is read as one number and the comma is dropped.

The example is loaded. Paste your own list to replace it.

1
Extract numbers

→ 3 lines

From each line take

Allow decimals (12.50)

Allow minus signs (-3)

Read 1,299 as one number and drop the comma

Drop lines with no number

Your text

3 lines

Result

3 lines

What it does

Pull numbers out of text, like prices or counts.

Settings you can change

  • From each line take: The first number, Every number (one per line)
  • Allow decimals (12.50)
  • Allow minus signs (-3)
  • Read 1,299 as one number and drop the comma
  • Drop lines with no number

When to use it

Prices came out as "From $1,299.00 per month". Keep only 1299.00 so a spreadsheet can add them up.

Example: extract numbers from text

Input

Result

Used in these recipes

Often used with

Total, average, smallest and largest of the numbers in the list (first number in each line).

A to Z, Z to A, or by number.

Keep (or remove) lines that are numbers, emails or links.

All free tools

Your text stays on this computer
The list editor works on your computer. The text you paste or open is not uploaded or stored by HeyScraper, and closing the page clears it. Saved recipes are kept in this browser only.

Got your list from a web page?

HeyScraper turns the page you’re on into a spreadsheet, so you can skip the copying and pasting. Free: 500 pages a month.

Get HeyScraper