Format Constraints
Format constraints apply regex-based validation to schema fields. They are evaluated post-extraction in Phase 4 of the pipeline, after all transforms have been applied. Original values are preserved for audit in original_extractions.
Mismatch behaviors
| Parameter | Type | Description |
|---|---|---|
| empty | default | If the extracted value does not match the regex, the cell is cleared. The original is preserved for audit. |
| flag | behavior | The value is kept but flagged with a format_applied indicator. Visible as an amber dot in the results grid. |
| constant | behavior | The value is replaced with a constant you specify (e.g. "INVALID", "N/A"). |
Define format constraints in the schema field editor. The pattern uses standard regex syntax. The editor provides a live test input so you can verify the pattern before saving.