Free tool
Get a substring by position
Get a substring by position from every line: the first few characters, the last few (with a minus number), or any part in between.
The example is loaded. Paste your own list to replace it.
→ 2 lines
Start at character (1 = first; -4 = fourth from the end)
How many characters (0 = to the end)
Your text
Result
What it does
Keep part of each line by character position: the first 5 characters, the last 4, from the 3rd on.
Settings you can change
- Start at character (1 = first; -4 = fourth from the end)
- How many characters (0 = to the end)
When to use it
Order numbers look like "2026-ORD-00412" and you only need the last five digits.
Example: substring by position
Settings used: Start at character (1 = first; -4 = fourth from the end): -5.
Input
Result
Tips
- Start 1 and length 3 keeps the first 3 characters. Start -3 keeps the last 3.
Often used with
Cut each line to a maximum number of characters.
Keep only the parts of each line that match a pattern (regular expression).
Split each line at a separator into tab-separated columns (pastes into a spreadsheet as columns).
Your text stays on this computer
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