Object-Oriented Programming · Microsoft · Medium
Part 1 — CSV-Backed In-Memory Table A State-Machine Parser With a Linear-Scan select Splitting a CSV line on commas is tempting but wrong the moment a quoted field contains a comma or a newline. The reliable way to decode this format is to read the text character by character and track which of four situations we are in: just after a field boundary (FIELD_START), inside a bare field (IN_UNQUOTED), inside a quoted field (IN_QUOTED), and just after a closing quote…
Checking your access…