parse_table
Parse delimited text into a header and rows while handling quoted fields, escaped quotes, embedded delimiters, and newlines. Auto-detects delimiters to avoid broken comma splitting.
Instructions
Parse delimited text into a header plus rows, handling quoted fields, escaped quotes, embedded delimiters and embedded newlines (RFC 4180 style). If no delimiter is given, the most frequent candidate on the first line is chosen and reported back. Use instead of splitting on commas, which breaks on any real CSV.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| text | Yes | Delimited text | |
| maxRows | No | Row cap (default 5000) | |
| delimiter | No | Single-character delimiter; auto-detected if omitted | |
| hasHeader | No | Treat the first row as a header (default true) |