Pull IDs from operational exports
Extract just the account ID, email, SKU, or timestamp column before sharing the smaller list.
Delimited Text Extractor
Extract one field from CSV, TSV, pipe-separated text, or log lines when an export contains more columns than you need.
Practical guide
Extract one column or segment from delimited text when a CSV, TSV, pipe-separated list, or log export contains more fields than you need.
Where this fits
Move extracted values into structured data
convert CSV to JSON when the extracted data still needs object records.
How to use Delimited Text Extractor
- 1Paste the delimited textUse a small sample first if the export has unusual quoting or separators.
- 2Choose delimiter and columnMatch the source format, then select the field position you want.
- 3Copy the extracted linesCheck the first few rows against the original before using the output.
Column extraction workflow
- 1
Extract field
- 2
Remove Duplicate Lines
- 3
CSV to JSON
Questions worth checking
Why does the wrong column come out?
The delimiter may not match the source, or quoted fields may contain the separator character.