Comparing Excel sheet with CSV

This topic contains 2 replies, has 2 voices, and was last updated by  Miguel 7 months, 2 weeks ago.

  • Author
    Posts
  • #68376

    Miguel
    Participant

    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

  • #68380

    Sam Boutros
    Participant

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

  • #68455

    Miguel
    Participant

    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.

You must be logged in to reply to this topic.