Tapatalk

Error in file construction - wrong word count!

Error in file construction - wrong word count!

1
NewbieNewbie
1

    Apr 27, 2009#1

    Hi, I am trying to prepare a file for processing with another program. I have some rows (1,000) and columns (20,000) separated by tabs ("\t"). So basically it's 1000 lines with 20,000 entries with a tab in between them. I have then inserted a header, that is 1 row and the same number of entries (20,000) with tabs in between.

    Now, if I paste in this data, I get a word count error, so that the final word count is NOT 1001 rows x 20,000 columns. The weird thing is that I get 20,000 for the header row and 200,000 (1,000 x 20,000) for the body, but always the total for the document is 206,000! I tried using PERL scripts to add this together, using tab, space, etc. and every time the word counts are okay individually (and the individual files), but for the whole document they are wrong. I have also tried to insert the data file after the header file, copy/paste, etc., and every time this happens.

    What could this be? Perhaps some encoding error? I have done the same thing previously with more data and it worked without a hitch.

    Thanks,
    D R

    61
    Advanced UserAdvanced User
    61

      Apr 27, 2009#2

      I see 20,000 * 1,000 = 20,000,000

      and 1,001 * 20,000 = 20.020,000



      :D