Long values and line breaks — Trusty CSV User Guide
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``⌥⌘Eunfolds 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.