Record count
Posted: Thu Jan 29, 2015 9:51 pm
Charles
The record count in the status bar may not be correct, and this can create confusion. This file is a directory listing and has 2354 records each 60 bytes long (the folder names), plus 4,606,022 records each 74 bytes long (the file names). This gives a total file size of 340,986,868 bytes (the record length includes the CR/LF). The record count in the status bar is 4,607,930 - which is the file size divided by 74. The Count Word/Lines finds the correct number of 4,608,376. If I load the entire file, rather than chunks, the record count is shown as the correct value of 4,608,376.
I was relying on the count in the status bar to compare two similar files, and couldn't understand the discrepancy I was seeing. I understand it is easy to assume that since so many of the records are the same length that it can be used to calculate the record count. Could you at least update the status bar to the value found from the Count Words/Lines tool if that has been run.
Chris
The record count in the status bar may not be correct, and this can create confusion. This file is a directory listing and has 2354 records each 60 bytes long (the folder names), plus 4,606,022 records each 74 bytes long (the file names). This gives a total file size of 340,986,868 bytes (the record length includes the CR/LF). The record count in the status bar is 4,607,930 - which is the file size divided by 74. The Count Word/Lines finds the correct number of 4,608,376. If I load the entire file, rather than chunks, the record count is shown as the correct value of 4,608,376.
I was relying on the count in the status bar to compare two similar files, and couldn't understand the discrepancy I was seeing. I understand it is easy to assume that since so many of the records are the same length that it can be used to calculate the record count. Could you at least update the status bar to the value found from the Count Words/Lines tool if that has been run.
Chris