Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2016
    Posts
    1

    Default Compare top colum values in CSV files

    I am doing exports of data to CSV files and then need to import an altered CSV file. My problem is the new CSV files have column headers that might not match up that I need to identify and fix before importing. I must be missing how to compare column header names to determine differences. The columns would look something like below with new columns I will need to populate in the second file. For example the first one I want to compare the old file had 138 different columns while the new file has 145. I need to see the 7 column headers that don't match in order to add them to the old file and populate them with data.

    Value 1, Value 2, Value 3
    1,2,3

    Value 1, Value 2, Value a, Value 3
    1,2,x,3

  2. #2
    Join Date
    Oct 2007
    Location
    Madison, WI
    Posts
    4,609

    Default

    Beyond Compare's default settings detect if the first line is a column header or data. If it detects as a column header, it will use the headers from the left file and won't display the headers with the other data.

    To force the first line in each file to be treated as data so it is displayed, click the Format toolbar button in the Table Compare. In the Type tab, change "First line contains" from "Detect" to "Cell data".
    Chris K Scooter Software

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •