Hello all,
I´ve a script to compare a CSV (into array)file with Excel as Database. CSV file are numbers to inactivate and the idea is if the number doesn´t match, it´ll export to a file. When CSV value is the same works perfectly, but If doesn´t match, it exports all numbers from excel. How Could export only mismatched value?
Regards
In the beginning of line 17, replace $Csv with $item
Hello Sam,
I did it and it generated a file with all numbers.An example:
CSV. Last number is different than Excel
710377057
13697645
749166209
736940169
837598441
943435113
123456789
567890113
Excel
710377057
13697645
749166209
736940169
837598441
943435113
123456789
763893584
And it generate this eight times:
710377057
13697645
749166209
736940169
837598441
943435113
123456789
567890113
It exports all values but not the mismatched value.I don´t know why happen this.