No announcement yet.

How to compare two files that have data in different position. (P1)

  • Filter
  • Time
  • Show
Clear All
new posts

  • How to compare two files that have data in different position. (P1)

    HI all,

    i have problem. I have two files that i need to compare. Both files have same data in common but this informations are in a differents position (rows). How can i compare this data if i want to find all the common data "in the file but not in the same position". For example.

    File 1

    Row Data
    1 A
    2 B
    3 C

    File 2

    Row Data
    1 B
    2 A
    3 Z


    A , B

  • #2
    In the Text Compare, you would need to Sort the rows. This can be done using the built in Sorted format (Tools menu -> File Formats: Sorted) and selecting it from the formats dropdown when comparing your files, or creating a custom format using an external program or script to perform the sorting:
    Beyond Compare is a multi-platform utility that combines directory compare and file compare functions in one package. Use it to manage source code, keep directories in sync, compare program output, etc.

    What extension are these files? If they are delimited data with Key columns, you can use the Data Compare, which will sort on the Key column (right click any column header to set as Key, Standard, or Unimportant). After sorting and aligning based on the Key, the row is compared.
    Aaron P Scooter Software


    • #3
      I have a member file with 10k of data and the second one with 15k of data which 5k member has been added. The order can be different. Will the BC3 be able to compare?


      • #4

        Sorting would need to be done. The Text Compare can use the Sort format, or if you 'data' is row/column based (Excel or CSV, etc) you can use the Data Compare and sort/align on the Key column (and you can customize which column/s are the Key).
        Aaron P Scooter Software