🔢CSVs

Use the following command to create a cleaned and sorted version of your file:

sort -u codes_original.csv -o codes_clean.csv

You can also run this command to output duplicates values (in one or multiple files):

sort codes.csv|uniq -d # Single File
sort codes1.csv codes2.csv|uniq -d # Multiple Files

The following line can be used to identify "E+" patterns in your file, which indicates corrupted values:

grep -rn codes.csv -e 'E+'