0.14 should fix both those problems. Hope it works for you now!



select word, count('*') from list
group by word
.It would be cool if you have an alternative "remove duplicates".
It removes the duplicates, but ads a counter at the end with how many times a certain word appeared in the list.
EB000201
EB000201
EB000202
EB000202
EB000202
EB000203
EB000204
EB000205
EB000205
EB000205
EB000205
EB000205
EB000206 EB000201 (2)
EB000202 (3)
EB000203 (1)
EB000204 (1)
EB000205 (5)
EB000206 (1)
one
two
three
four
five
six
two
three
four
five
six
three
four
five
six
four
five
six
five
six
six1 - one
2 - two
3 - three
4 - four
5 - five
6 - sixone - 1
two - 2
three - 3
four - 4
five - 5
six - 6

Code | Code | Code | Code |
You actually can't separate by commas right now, because commas are used as a separator for the strings/characters by which you want to split. Kind of stupid. Will fix.thanks phitsc, looking forward to the fix.


Original address: https://www.donationcoder.com/forum/index.php?topic=36544.0