Extract with Regex from Parquet Files Online
Extract text matching a regular expression from Parquet files directly in your browser. Pull out emails, URLs, phone numbers, or any pattern into a new column — no upload required.
About this tool
Pull specific patterns out of text columns in a Parquet file using regular expressions. Extract emails, phone numbers, URLs, product codes, or any repeating pattern into a new column — ready to download. All processing runs locally in your browser.
Frequently Asked Questions
What regex syntax does the Parquet regex extract tool use?
This tool uses RE2 regular expression syntax. All common patterns work — character classes, quantifiers, alternation, and capture groups. Lookaheads and backreferences are not supported.
Can I extract multiple matches from one column in a Parquet file?
Yes. Choose "All matches" mode to extract every occurrence of the pattern from each cell, returned as a comma-separated list.
What happens if a row does not match the pattern in a Parquet file?
The extracted column will be null for that row. All other columns are preserved unchanged.
Is my data private?
Yes — completely. Your file is never uploaded to any server. Everything runs locally in your browser using WebAssembly — processing happens entirely inside your tab. Once you close the tab, nothing is retained.
What is the maximum file size?
The free limit is 50 MB. For larger files, performance depends on your device's available memory — most modern machines handle 500 MB to 1 GB comfortably.
Related Tools
Combine Columns in Parquet Files Online
Combine multiple columns into one in Parquet files directly in your browser. Merge first name and last name, join address fields, or concatenate any columns with a custom separator — no upload required.
Convert Case in Parquet Files Online
Convert text columns to UPPERCASE, lowercase, or Title Case in Parquet files directly in your browser. Apply case conversion to any or all text columns at once — no upload required.
Aggregate Parquet Files Online
Group and aggregate Parquet files by any column directly in your browser. Calculate sum, average, min, max, and count for any numeric column — no upload required.
Round Numbers in Parquet Files Online
Round numeric columns in Parquet files to any number of decimal places directly in your browser. Set precision per column with a simple slider — no upload required.
Add Conditional Column to Parquet Files Online
Add a new column to Parquet files based on an if/else condition directly in your browser. Set a value for rows that match and a different value for rows that don't — no upload required.