I have a file that would have been in a proper CSV format if it wasn't for the first line, which contains a short description and time stamp e.g. "Accounting entries for 12-Dec-2014". I would like to ignore this line in the Data Compare view.
Can BC3 ignore or remove automatically the first row so that the rest of the file can be treated as a CSV file and be compared in Data Compare view?
Data Compare view allows me to have rules around numeric tolerances for column names and have key columns etc.
Can BC3 ignore or remove automatically the first row so that the rest of the file can be treated as a CSV file and be compared in Data Compare view?
Data Compare view allows me to have rules around numeric tolerances for column names and have key columns etc.
Comment