Forum Moderators: coopster
I have a text file with pipe delimiter and I would like to know how to get the following stats.
Sample of text file.
ID¦Date
1¦10/07/2004
2¦09/07/2004
1¦10/07/2004
3¦09/07/2004
2¦10/07/2004
How I can generate the following.
1. how to get the count of IDS.
2. how to get the count of unique IDS.
3. how to get the count of unique IDS for today's date
Please help me if anybody has the code.
Thankyou
Babloo