Categories

← View All Tools

Number & Currency Extractor (数字/金额提取)

Extract numbers from text, supporting currency symbols and thousand separators

Extract amounts with currency symbols ($ ¥ € £ ₹ ¢ ₽)

Include decimal numbers in extraction

Choose how to format the extracted amounts

Filter out amounts below this value (optional)

Filter out amounts above this value (optional)

Key Facts

Category
Text Processing
Input Types
textarea, checkbox, select, number
Output Type
json
Sample Coverage
4
API Ready
Yes

Overview

The Number & Currency Extractor pulls numerical values and monetary amounts from text, recognizing currency symbols like $, €, and thousand separators for accurate data retrieval.

When to Use

  • •When extracting prices or amounts from unstructured text such as emails, documents, or web pages.
  • •For data cleaning tasks where numerical values are embedded in text and need to be isolated for analysis.
  • •To filter extracted numbers by a minimum or maximum value to focus on relevant financial data.

How It Works

  • •Paste or type the text containing numbers into the input field.
  • •Configure options: choose to include currency symbols, decimals, set the output format, and apply amount filters if needed.
  • •The tool scans the text and extracts all matching numbers based on your settings.
  • •View the extracted results in the chosen format, ready for copying or further use.

Use Cases

Extracting product prices from online listings or customer inquiries for e-commerce analysis.
Processing financial statements or invoices to pull out transaction amounts for accounting purposes.
Analyzing survey responses or reports where numerical ratings or amounts are mixed with descriptive text.

Examples

1. Extracting Invoice Amounts from Emails

Accountant
Background
An accountant receives email invoices with amounts embedded in text like 'Total: $1,234.56 due by Friday.'
Problem
Manually copying amounts from multiple emails is time-consuming and prone to errors.
How to Use
Paste the email text into the tool, enable 'Include Currency Symbols', and set 'Output Format' to 'Standardized'.
Example Config
includeCurrency=true, includeDecimals=true, format=standardized
Outcome
All invoice amounts are extracted as plain numbers, e.g., 1234.56, ready for quick import into spreadsheets.

2. Filtering High-Value Transactions in Reports

Financial Analyst
Background
A financial report contains numerous transaction descriptions with amounts like 'Payment of €500 received' and 'Expense: €2000 for supplies'.
Problem
Need to identify only transactions above €1000 for a focused review.
How to Use
Input the report text, set 'Minimum Amount' to 1000, and choose 'Raw' format to preserve original details.
Example Config
minAmount=1000, format=raw
Outcome
Only amounts greater than 1000 are extracted, such as €2000, helping prioritize significant transactions.

Try with Samples

text
Number & Currency Samples
Text containing various number and currency formats for testing currency extraction
title token number,currency
text
Phone Number Extractor Samples
Collection of mixed text containing phone numbers from various countries for extraction testing
title token number,extractor
text
Markdown Link Extractor Samples
Sample Markdown documents with various link types for testing the Markdown Link Extractor tool
title token extractor
text
Changelog Extractor Samples
Various changelog formats for testing changelog parsing and extraction tools
title token extractor
text

Related Hubs

Text Convert Tools
Explore 80 text tools for convert workflows and compare closely related utilities quickly.
Text Tools
Explore 33 text tools for utility workflows and compare closely related utilities quickly.
Text Analyze Tools
Explore 12 text tools for analyze workflows and compare closely related utilities quickly.
Text Format Tools
Explore 9 text tools for format workflows and compare closely related utilities quickly.

FAQ

What currency symbols are supported?

Symbols like $, ¥, €, £, ₹, ¢, and ₽ are recognized in the extraction.

Can I extract only whole numbers without decimals?

Yes, by unchecking the 'Include Decimals' option, only integers will be extracted.

How does the 'Standardized' output format work?

It converts extracted amounts to plain numbers without currency symbols or thousand separators.

What if I want to exclude small amounts from the results?

Use the 'Minimum Amount' filter to set a threshold and ignore values below it.

Is the extraction case-sensitive for currency symbols?

No, the tool handles symbols regardless of case or context in the text.

API Documentation

Request Endpoint

POST /en/api/tools/currency-extractor

Request Parameters

Parameter Name Type Required Description
text textarea Yes -
includeCurrency checkbox No Extract amounts with currency symbols ($ ¥ € £ ₹ ¢ ₽)
includeDecimals checkbox No Include decimal numbers in extraction
format select No Choose how to format the extracted amounts
minAmount number No Filter out amounts below this value (optional)
maxAmount number No Filter out amounts above this value (optional)

Response Format

{
  "key": {...},
  "metadata": {
    "key": "value"
  },
  "error": "Error message (optional)",
  "message": "Notification message (optional)"
}
JSON Data: JSON Data

AI MCP Documentation

Add this tool to your MCP server configuration: 

{
  "mcpServers": {
    "elysiatools-currency-extractor": {
      "name": "currency-extractor",
      "description": "Extract numbers from text, supporting currency symbols and thousand separators",
      "baseUrl": "https://elysiatools.com/mcp/sse?toolId=currency-extractor",
      "command": "",
      "args": [],
      "env": {},
      "isActive": true,
      "type": "sse"
    }
  }
}

You can chain multiple tools, e.g.: `https://elysiatools.com/mcp/sse?toolId=png-to-webp,jpg-to-webp,gif-to-webp`, max 20 tools.

If you encounter any issues, please contact us at [email protected]