Search Results

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

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

so with...

Oh! I've launched the command:

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 >...

I attach an example of the two files (only some rows...files are too big:()


in the second file, fields from 2 to 5 are with the same data.

PS: the real file1 is more big of file 2...is that a...

Ok, I've tried with:
awk -F\; 'NR == FNR && NR > 1 {T[$1]; next} {for (i=2; i<=5; i++) if ($i in T) delete T[$i]} END {for (t in T) print t}' Magento_2.csv Salesforce_Active_OK.csv > Output.csv
...

Hi RudiC,


many thanks.
the code not works.

I launched the command. I took one of the data from the output file and verified that it was not in file 2 but:
grep 63995855...

Hi all,

i need help.
I have two csv files with a huge amount of data.
I need the first column of the first file, to be compared with the data of the second, to have at the end a file with the...