Delimited text guides

Extract and reorder two columns from a quoted table

·

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.

Text Column Extractor

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.

RFC 4180 CSV fields and quoting rules

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.

RFC 4180 CSV fields and quoting rules

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.

RFC 4180 CSV fields and quoting rules

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.

Sources

Put it into practice.

Related guides