I frequently use the ‘compare files’ utility to compare code such as sql and also .txt files which often contain data.
I often notice that my data files seem to have rows repeated, for example, I produced a data file today to compare to one from yesterday. The files both had about the same number of rows, 2431, and are in the same sequence. However, the compare showed a row count of 3495.
What is causing some of the rows to appear more than once?
I did a clean install on a new computer recently so there should be no leftover settings or anythign else affecting the program.