CSV Surgery, Without Opening a Spreadsheet SPLIT
A spreadsheet will turn an identifier into a date, drop the leading zero off a postcode and convert a long number to scientific notation, and mention none of it.
The file
Read in this tab. Nothing is uploaded and nothing is converted: a value that went in as 007 comes out as 007.
Operations
Remove duplicates
Rows by a test
Keep columns, in this order
Sort
Tidy
One file per value
The table
What was done to it
Questions people ask about SPLIT