Back to Tools

Advanced Data Extractor

Scrape, filter, and export specific data points from bulk text using intelligent regex

PRO EXTRACTOR
Source Text
Extraction Results
# Extracted Value Action

Pull every match out of a wall of text

Sometimes you do not want to edit text; you only want the pieces that match a pattern, such as every email address in a pasted document or every order number in a log dump. The Regex Extractor runs your regular expression across the source text, collects each match into a numbered table, and lets you download the list. Copying matches by hand from a long export is slow and easy to get wrong, and this reduces it to one pattern and one click.

Extracting step by step

  1. Enter a regular expression in Extraction Pattern. It arrives pre-filled with an email pattern you can keep or overwrite.
  2. Under Extraction Settings, leave Unique Only ticked to remove repeated values, and tick Case Sensitive if capitalisation matters. When unticked, matching ignores case.
  3. Paste your material into Source Text. The Paste button reads from your clipboard, Sample loads an example containing several email addresses, and Clear empties the box.
  4. Press Start Extraction Process.
  5. Review the table of numbered values, copy a single one with the button on its row, or export the whole list with Text, JSON or CSV.

Reading the results

Above the table, three badges show total matches found, how many are distinct, and whether the unique filter was applied. The CSV export has two columns, an ID and the Value, with quotes escaped correctly. JSON export gives a simple array of strings. Text export gives one match per line.

Typical uses

  • Collecting all email addresses from a contact list pasted out of a document.
  • Isolating IP addresses or URLs from server logs before further analysis.
  • Listing product codes or invoice numbers embedded in messy supplier emails.
  • Grabbing hex colour codes from a stylesheet to build a palette.

Limits and edge cases

The extractor always searches globally, so every occurrence is found. It returns the full text of each match, not individual capture groups, so wrap your pattern so that the entire wanted value is the match. If the pattern is invalid, an error message appears inside the results table instead of a list. Uniqueness compares exact strings, meaning two addresses that differ only in capitalisation count as different unless Case Sensitive is off and you normalise them yourself. Very broad patterns such as a lone dot can return an enormous list, so test on a small sample first. Processing happens in your browser using JavaScript, and a pattern that backtracks heavily on large text may slow the page.


Related Tools

Related Tools


Frequently Asked Questions

What does the Unique Only option do?
It removes repeated values from the extracted list, so an address that appears five times is listed once. The stats badges still show the total match count alongside the unique count, so you can see how many duplicates were dropped.
Which export formats are available?
You can download the results as plain text with one value per line, as a JSON array, or as a CSV with ID and Value columns. Each row in the table also has its own copy button for grabbing a single match.
Does the extractor return capture groups?
No. It returns the full text of each match. If you only want part of a match, use lookarounds or restructure the pattern so the exact portion you want is the whole match. The Regex Tester shows capture groups if you need to inspect them.
Why does the default pattern find email addresses?
The field is pre-filled with a common email pattern as a working example. Replace it with any expression you like, such as a phone number, URL or date format. The Sample button loads text with several addresses so you can see it work immediately.
What happens if my pattern is invalid?
The results area displays the error message returned by the JavaScript regular expression engine, for example an unterminated group. Fix the pattern and run the extraction again. Nothing is exported when there are no valid matches.
Support Chat
We typically reply within minutes

Hello! 👋 Before we start, please tell us your name.