How would you get a count for each of $ delimited Individuals in each of the group_names? (Example: SomeGroup has 1, This Is Another Group has 8)
thedb=# select group_name,encode(group_data,'escape') from groupedup.singlulars;
group_name | encode
-----------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------
This Is One Group |
This Is Another Group | #
+
| #Mar 15 14:58:18 PDT 2012
+
| Buckets=ALL
+
| Individuals=33$62$35$380$357$360$356$353
+
|
HiImAGroup | #
+
| #Feb 25 17:46:42 PST 2015
+
| Individuals=433
+
|
AnotherGroup | #
+
| #Dec 04 15:58:21 PST 2014
+
| Individauls=66$323$148$152$133$329$319$205$279$240$241$211$159$350$255$129$250$208$209$572$26
+
|
SomeGroup | #
+
| #Dec 04 15:57:34 PST 2013
+
| Individuals=226
+
|
