Extract and reorder two columns from a quoted table
Admin ·
An export can repeat a heading, omit a field in some records, or use commas inside a value. Select by position to keep the fields you intend to hand off.
Select the second Note column by its position
Load the example and select Extract columns. The source headings are Task, Note, Status and Note. The selected positions 4, 1 put the second Note first, followed by Task.
The first data row exports café and Map, east. The comma in Map, east stays inside one quoted field. The last task is River and walk on two lines. Its quoted line break remains in that field.
Compare keeping, skipping and reporting a missing field
The South record has only three fields. The default keeps it with an empty cell in the selected Note column. Choose JSON arrays and extract again to see its absent value as null.
Choose Skip the record to leave South out of the export. Choose Stop and report the record to see which data record is missing a selected column before downloading.
Save the columns in positional order
Keep the headings selected when the export needs a table header. Use positions 4, 1, 4 to repeat the second Note at both ends. In JSON arrays the headings and row values follow those exact positions.
Download CSV or TSV for a delimited import. Reopen it with quoted fields enabled and compare the number of data records with the report.
Common questions
Does a newline inside a quoted field start a record?
With Parse quoted fields enabled, a newline between an opening and closing quote stays part of that field.
How do I extract from a table with a separator such as two colons?
Select Custom, enter the literal separator, and keep the same numbered column list.