Hi All,
I noticed that there is a thread in "Text Compare" regarding this.
However, this request is a little different. When comparing CSV files to Excel Spreadsheet, it treats them as a "Data Compare", and not as a text compare.
I'm running into the issue where the CSV file has a Line Feed, whereas the Excel Spreadsheet has Carriage Return and Line Feed. So far, I have to do some post processing to filter these out, but it take a bit of time. I'm viewing the Data Compare Report as an HTML (only the columns that I care about and have a difference), and then viewing the html I can ignore the items that show up as "differences" between
It would help immensely to have more options when comparing CSV and spreadsheet files, and allow it to ignore this type of white space.
I noticed that there is a thread in "Text Compare" regarding this.
However, this request is a little different. When comparing CSV files to Excel Spreadsheet, it treats them as a "Data Compare", and not as a text compare.
I'm running into the issue where the CSV file has a Line Feed, whereas the Excel Spreadsheet has Carriage Return and Line Feed. So far, I have to do some post processing to filter these out, but it take a bit of time. I'm viewing the Data Compare Report as an HTML (only the columns that I care about and have a difference), and then viewing the html I can ignore the items that show up as "differences" between
Code:
<span class="DataSegSigDiff"></span>
Comment