No announcement yet.

Trailing Zeros are truncated for CSV files while comparison

  • Filter
  • Time
  • Show
Clear All
new posts

  • Trailing Zeros are truncated for CSV files while comparison

    Hi Team,

    We have two files csv files , in the files we have few decimal numbers as below:

    File1--- > File2
    172629.28 --> 172629.28000

    after doing data compare, it should ideally show mismatch,but it truncates the zeros for second file and shows data is matching.

    172629.28 --> 172629.28 [Data match]

    We are using 3.3.13 version for Beyond Compare.

  • #2

    If a column in the Data Compare detects as Numeric, then the number value will be used and determined equal. If you would like to compare the text of the column, you can right click any column header and switch to Text Column instead of the detected Numeric column.

    This can be done per column, per session, or as an overall default for all future Data Compare sessions. To update defeaults, go to the Session Settings dialog, and in the Columns tab, Update Defaults or a specific column, set to Text, then switch from "use for this view only" to "also update session defaults."
    Aaron P Scooter Software