Regex Tester & Validator

Test, validate and match regular expressions

← GalleryCensus of Industrial Production✨ Emoji Combos

/^\s*(?<recno>$\d+$)\s+([^\d]+)\s+(?<r1_date>\d{4})\s+(?<r1_total>[\d,.]+)\s+(?<r1_salaries>[\d,.]+)\s+(?<r1_wagesearnings>[\d,.]+)\s+(?<r1_totalpersonsemployed>[\d,.]+)\s+(?<r1_proprietors>[\d,.]+)\s+(?<r1_salaried>[\d,.]+)\s+(?<r1_waged>[\d,.]+)\s+(?<r2_date>\d{4})\s+(?<r2_total>[\d,.]+)\s+(?<r2_salaries>[\d,.]+)\s+(?<r2_wagesearnings>[\d,.]+)\s+(?<r2_totalpersonsemployed>[\d,.]+)\s+(?<r2_proprietors>[\d,.]+)\s+(?<r2_salaried>[\d,.]+)\s+(?<r2_waged>[\d,.]+)\s*$/gmiPCRE+08 years ago✓ Pre-loaded

About this regex

Matches lines from a Census of Industrial Production report, capturing a record number, industry name, and two years of economic data (total, salaries, wage earnings, employment, proprietors, salaried, and waged figures). Useful for extracting structured tabular data from legacy text reports into fields for database ingestion or analysis. Handles commas and decimal points in numbers, and tolerates leading/trailing whitespace.

census industrial data-extraction text-parsing economic