Unquoted pipes divide a row into fields
All 8 scenarios hold
A missing field — from a leading, trailing, or doubled pipe — is captured as null.
expected outcome
broken scenario
| Scenario | Row | Fields? |
|---|---|---|
| Single field | a | [a] |
| Two fields | a | b | [a, b] |
| Three fields | a | b | c | [a, b, c] |
| No spaces around pipe | a|b|c | [a, b, c] |
| Trailing pipe adds a null | a | b | | [a, b, null] |
| Leading pipe adds a null | | a | b | [null, a, b] |
| Interior empty field is null | a | | c | [a, null, c] |
| Only pipes are all null | ||| | [null, null, null, null] |