Hello,
I have 10 texts files. These text files contain a different amount of records within them....anywhere from 100,000 records, to 6,000,000 records.
I need to select 16,000 random records from each of the 10 text files.
For those text files which have under 1,000,000 records, I can easily load them into excel...do a RAND() function and then sort to pull my sample. But what or how would I do this for the text files which contain more that the excel limit?
OR
Is there another way easier, that I am not aware of?
I have 10 texts files. These text files contain a different amount of records within them....anywhere from 100,000 records, to 6,000,000 records.
I need to select 16,000 random records from each of the 10 text files.
For those text files which have under 1,000,000 records, I can easily load them into excel...do a RAND() function and then sort to pull my sample. But what or how would I do this for the text files which contain more that the excel limit?
OR
Is there another way easier, that I am not aware of?