Shell Programming and Scripting

The code fails as your data have DOS line terminators (^M = \r = 0x0D = <CR>). Use sub (/\r$/, _); just before the T array assignment.

Oh! I've launched the command:

Code:

awk -F\; 'NR == FNR && NR > 1 {sub (/\r$/, _); T[$1]; next} {for (i=2; i<=5; i++) if ($i in T) delete T[$i]} END {for (t in T) print t}' file1.csv file2.csv > Output.csv

In the Output file, I've taken some random data and....nothing in the second file!

Many thanks RudiC! Now I must study and better understand the use of awk

Only a finally question. If I use a file that is the same of file 2 but without the field with data...for example have only one of the field (from 2 to 5) with data and the other empty...is the same command?

I don't understand your question.

for exmaple if in the second file there are rows like this:

Code:

005b0000004ODyTAAW;872693;;;;false;2017-10-27T18:23:59.000Z
005b0000004ZqRQAA0;425809;;;;false;2016-09-01T14:14:58.000Z

so with empty record

That will work; it will if either of the fields does compare.