Author Posts

April 9, 2017 at 3:28 pm

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

April 10, 2017 at 1:18 am

In the beginning of line 17, replace $Csv with $item

April 10, 2017 at 8:51 pm

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.