Timeline for Count distinct values of a field in a file
Current License: CC BY-SA 4.0
18 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Apr 26, 2022 at 9:12 | history | edited | thanasisp | CC BY-SA 4.0 |
reword
|
| Nov 20, 2018 at 22:36 | history | edited | Rui F Ribeiro | CC BY-SA 4.0 |
deleted 36 characters in body
|
| May 1, 2017 at 23:08 | history | edited | phk | CC BY-SA 3.0 |
added awk tag + spelling
|
| Jan 24, 2012 at 10:48 | vote | accept | Olgun Kaya | ||
| Jan 12, 2012 at 10:17 | history | edited | Nikhil Mulley | CC BY-SA 3.0 |
added 5 characters in body
|
| Jan 12, 2012 at 6:29 | comment | added | Olgun Kaya |
sorry for latency. I was out of internet connection. seperator is 2|' and field is field 28. I used; cat <file_name> | awk -F"|" '{if ((substr($2,0,8)=='20120110')) print $28}' | sort -u | wc -l the if clause was for another check of date as it seems obvious :)
|
|
| Jan 11, 2012 at 14:30 | comment | added | Nikhil Mulley | ok, then answer from @hesse would do your need. | |
| Jan 11, 2012 at 14:30 | answer | added | Peter.O | timeline score: 3 | |
| Jan 11, 2012 at 14:28 | comment | added | user13742 |
@Nikhil This is clear from the question: ... No matter of how many times a value is repeated, it should be counted as 1. ...
|
|
| Jan 11, 2012 at 14:27 | comment | added | Nikhil Mulley | btw, do you want the value to be counted as 1 irrespective of how many times it exists, or you want the count of the number of occurrences/repetitions? if you just want it to be counted once, then how the distinct values are counted? Can you please check my edit on your question and confirm if I am right in interpreting. | |
| Jan 11, 2012 at 14:26 | history | edited | Nikhil Mulley | CC BY-SA 3.0 |
edited body; edited tags; edited title
|
| S Jan 11, 2012 at 14:26 | history | suggested | user13742 | CC BY-SA 3.0 |
edited tags
|
| Jan 11, 2012 at 14:23 | review | Suggested edits | |||
| S Jan 11, 2012 at 14:26 | |||||
| Jan 11, 2012 at 14:21 | answer | added | Nikhil Mulley | timeline score: 44 | |
| Jan 11, 2012 at 14:20 | comment | added | Nikhil Mulley | it would be more easier, if you could just give a glimpse of format of the file..not necessarily the data. | |
| Jan 11, 2012 at 14:20 | history | edited | user13742 |
edited tags
|
|
| Jan 11, 2012 at 14:18 | answer | added | user13742 | timeline score: 7 | |
| Jan 11, 2012 at 14:08 | history | asked | Olgun Kaya | CC BY-SA 3.0 |