Closed stucka closed 7 months ago
Testing with
csvcut -n co-old.csv to get a list of columns
workforce_region jobs location occupations permanent_job_losses dropdown letter naics end_date email at_the_location contact fein notice_date temporary_job_losses company received_date reason begin_date reduced_hours furloughs phone workforce_area
workforce_region,jobs,location,occupations,permanent_job_losses,dropdown,letter,naics,end_date,email,at_the_location,contact,fein,notice_date,temporary_job_losses,company,received_date,reason,begin_date,reduced_hours,furloughs,phone,workforce_area
csvsort co-old.csv >csv-old-sorted.csv
csvcut -c workforce_region,jobs,location,occupations,permanent_job_losses,dropdown,letter,naics,end_date,email,at_the_location,contact,fein,notice_date,temporary_job_losses,company,received_date,reason,begin_date,reduced_hours,furloughs,phone,workforce_area co-new-original.csv | csvsort >co-new-sorted-trimmed.csv
diff co-new-sorted-trimmed.csv co-old-sorted.csv
Testing with
csvcut -n co-old.csv to get a list of columns
workforce_region jobs location occupations permanent_job_losses dropdown letter naics end_date email at_the_location contact fein notice_date temporary_job_losses company received_date reason begin_date reduced_hours furloughs phone workforce_area
workforce_region,jobs,location,occupations,permanent_job_losses,dropdown,letter,naics,end_date,email,at_the_location,contact,fein,notice_date,temporary_job_losses,company,received_date,reason,begin_date,reduced_hours,furloughs,phone,workforce_area
csvsort co-old.csv >csv-old-sorted.csv
csvcut -c workforce_region,jobs,location,occupations,permanent_job_losses,dropdown,letter,naics,end_date,email,at_the_location,contact,fein,notice_date,temporary_job_losses,company,received_date,reason,begin_date,reduced_hours,furloughs,phone,workforce_area co-new-original.csv | csvsort >co-new-sorted-trimmed.csv
diff co-new-sorted-trimmed.csv co-old-sorted.csv