Pull signed numbers and decimal values from mixed text. Use the list to inspect figures in notes before cleaning or calculating them.
How to use
Paste the passage and review the extracted values. Exact repeats appear once. Check decimal separators before moving the results to a spreadsheet.
Example
Invoice 42: amount 12.50 and adjustment +3 returns 42, 12.50, and +3 on separate lines.
FAQ
How are thousands separators handled?
Commas and periods are read as decimal separators. A formatted value such as 1,234,567 needs cleanup first.
Related tools
A practical task
Identify the role of each extracted value before calculating. A report can mix invoice identifiers, dates, amounts, and counts. The extractor finds numeric patterns in all of them; it does not label a number as a price or a year.
Another useful question
Can I sum the output immediately?
Only after checking units, signs, and decimal notation. Do not add order numbers or parts of dates to monetary amounts simply because they appear in the same result.
Details for interpreting the result
| Detail | Explanation |
|---|---|
| Extracted values | Extraction identifies text that matches a rule. It does not establish that the result is a real person, a working address, or a valid business value. Validate the extracted data according to its intended use. |
| Pattern and literal search | A literal search matches the typed characters. A regular expression describes a pattern with operators. Characters such as dots and brackets have different roles in the two systems, so choose the right search mode. |
| Case sensitivity | Case sensitive matching distinguishes capital and lowercase letters. Ignoring case merges some of those distinctions, but it does not turn different spellings or word forms into the same term. |
| Literal separators | A literal separator is an exact sequence of characters, including any spaces. A comma and a comma followed by a space are different separators. Match the source consistently before extracting or exchanging fields. |
| Similar looking text | Two strings can look identical but use different Unicode sequences. An accented letter can be stored directly or as a letter plus an accent. Visual similarity alone does not establish byte equality. |
| Column headers | Headers provide names for columns; they are not extra data values. Keep their order aligned with each row. When building objects, duplicate header names create ambiguity about which value belongs to a key. |
| Strings and values | The JSON string "12" differs from the number 12, and "false" differs from false. Type changes affect comparisons and imports. Keep identifiers as strings when their leading zeros or exact digits matter. |