Re: Frequency occurence of same words in a file

[davido]

Would 0011 Sally ever appear more than once? And if so, would the output contain two listings of Sally, or one?

0011 Sally
0011 Sally
0011 Sally
# This? -------------
0011 ---> 3
Sally
Sally
Sally
# Or this? ----------
0011 ---> 3
Sally

So the first question is what to do with collisions of the same name within the same prefix.

Also, what is the min and max for the numeric range? How many distinct numeric prefixes are there, and does the maximum prefix change over time?

I'm just wondering, as the solution may be different if we know more about the input data.

[geek12]

Hi, 0011 Sally will be the only occurrence. Only coulmn on left can be multiple times but the right column will be unique. I was able to get the first solution working. thank you for the help.