Keyboard

↓ ↑
move between the rows you can see
→
open a feature, then step into it
←
close a feature, or step out to the one above
Enter
go to the page in focus
Tab
the same rows, plus everything else on the page
/
search the whole report
m
open or close the navigation drawer
Esc
leave the search box, or close the drawer
?
this list

Divides a row into fields at each unquoted pipe

All 8 scenarios hold

These rules cover how one line divides into fields. They apply before the parser reads a field as a value.

Each Row below is parsed as the only data row under a one-column header. Fields shows the captured field list, printed back out. Fields is text rather than a list column because a list cannot hold a null element: writing [a, , c] is itself a parse error. A null field is what several of these rules are about.

A leading pipe, a trailing pipe, or two pipes together leave a field with no text. The parser captures that field as null.

Spacing around a pipe changes nothing. One row carries both spellings of the same three fields, in place of two rows with one expectation between them.

expected outcome broken scenario
ScenarioRowFields?
No pipe at alla[a]
One pipea | b[a, b]
Spaced or unspaced pipes
  • a | b | c
  • a|b|c
[a, b, c]
A trailing pipea | b |[a, b, null]
A leading pipe| a | b[null, a, b]
An empty field between pipesa | | c[a, null, c]
Nothing but pipes|||[null, null, null, null]