Compare CSV files, resulting with:
- A file (_upsert.csv) with the newly created/updated lines
- A file (_delete.csv) with the deleted lines
svelta.sh old_data.csv new_data.csv
Having new_data.csv...
id,first_name,last_name,email,gender,ip_address
6,Hildy,Loram,[email protected],Female,149.73.190.209
4,Marthena,Fernando,[email protected],Female,100.128.150.95
1,Leyla,Culligan,[email protected],Female,214.35.5.12
2,Melloney,Lafontaine,[email protected],Female,59.173.34.20
3,Amye,Grafhom,[email protected],Female,103.211.219.108
5,Zachariah,Kenway UPDATED,[email protected],Male,195.4.181.117
...and old_data.csv...
id,first_name,last_name,email,gender,ip_address
2,Melloney,Lafontaine,[email protected],Female,59.173.34.20
7,Bertram,Limpkin,[email protected],Male,191.68.118.149
4,Marthena,Fernando,[email protected],Female,100.128.150.95
5,Zachariah,Kenway,[email protected],Male,195.4.181.117
1,Leyla,Culligan,[email protected],Female,214.35.5.12
6,Hildy,Loram,[email protected],Female,149.73.190.209
3,Amye,Grafhom,[email protected],Female,103.211.219.108
...will generate new_data_upsert.csv...
id,first_name,last_name,email,gender,ip_address
4,Marthena,Fernando,[email protected],Female,100.128.150.95
5,Zachariah,Kenway UPDATED,[email protected],Male,195.4.181.117
...and new_data_delete.csv...
id,first_name,last_name,email,gender,ip_address
7,,,,,