reading your data

Long values and line breaks

Values longer than their column fold into “…” and values with line breaks fold into one line, so that every row stays one aligned line. One click shows them whole.

A single long description, or an address with line breaks inside it, would push a whole column out of line, or break a row into several. Trusty CSV folds them so that every row stays a single line and the columns stay aligned.

support-tickets.csv
id,subject,status,description
101,Login fails,open,"After the last update the login page shows a blank screen in Firefox, but works in Chrome"
102,Export to Excel,closed,Numbers are exported as text when the column has a currency symbol
103,Invoice address,open,"The customer moved:
new address in the attached note"
104,Slow search,open,Searching a list of more than ten thousand contacts takes several seconds
id · Row 1

Long values

A column is never wider than 32 characters. A longer value shows its beginning followed by a grey …. Click the …, or move the cursor into the value, and it unfolds, that cell only, so that you can read and edit it; it folds again when the cursor leaves. Ctrl+Click⌘Click on several … opens all of them at once (each click adds a cursor).

To read a long column, unfold the whole of it:

  • Ctrl+Alt+E⌥⌘E unfolds the column of the cursor, or folds it again (View › Expand/Collapse Column).
  • A right click in it does the same.
  • In the column bar above the rows, the three dots where a column ends open its menu: Expand Column unfolds a column with long values, and Collapse Column folds it again.
  • View › Expand All Columns and View › Collapse All Columns do it for every column.

View › Appearance › Collapse Long Values turns folding off altogether: each column is then as wide as its longest value.

Line breaks inside a value

A value between quotes can have line breaks in it, and then it is still one value, and the row is still one row. Trusty CSV shows such a value on one line, its first line and a …, and unfolds it like a long value, when the cursor goes in or with a click on the ….

Moving rows, sorting, removing duplicates and every other operation take the row whole, with all the lines of its values.

Unclosed quotes

A value that starts with a quote goes on until the closing quote, even across lines. A quote that is never closed would make the rest of the file one value; so when a quote doesn’t close within the next 1,000 lines, Trusty CSV reads it as an ordinary character, and says so.

The status bar then shows how many there are (1 unclosed quote). Click it, or press F8, to open the Quality Check panel and select the next one, and close the value or remove the quote.