Extract from Text
Pull every email address, link, number, hashtag or mention out of a block of text, with the duplicates removed.
Results
What this tool does
A forwarded thread, a scraped page, a meeting note: somewhere in it are the six addresses you need, or the links, or the figures. Finding them by eye is slow and you always miss one. Paste the text, choose what to look for, and they come back as a clean list in the order they appeared, with the repeats collapsed and counted separately. The text stays in your browser.
Formula
searches the text for the patterns of each kind and returns them without repeats, in the order they appear
Variables
| Symbol | Meaning | Unit |
|---|---|---|
text | Your text | — |
kind | What to pull out | — |
OUT | What was found | — |
FO | Found in all | — |
UQ | Different ones | — |
RP | Repeats | — |
F1 | The first | — |
AL | All on one line | — |
Worked example
- Your textWrite to ana@example.com or bob@test.org before Friday. The brief is at https://example.com/brief and the old one at www.example.net. Budget is 12500, deadline in 14 days. Tag it #launch #q4 and copy @paulo.
- What to pull outemail
- What was foundana@example.com bob@test.org
- Found in all2
- Different ones2
- Repeats0
- The firstana@example.com
- All on one lineana@example.com, bob@test.org
Limitations
- The calculation runs entirely in your browser. The values you type are never sent to a server.
Frequently asked questions
Does it check that the addresses are real?
No, and it makes no attempt to. The patterns are deliberately simple and generous: they find what looks like an address in a block of pasted text, which is a different job from deciding whether a mailbox exists or whether a string is valid under the email standard. Anything picked up here still needs checking before you send to it.
Why are duplicates removed?
Because the usual reason for pulling addresses or links out of a text is to do something with each one once. The list keeps the first of each, in the order they appear, and the count above tells you how many there were in total — so you can see at a glance that a page mentioning forty links really only has twelve distinct ones.