 |
morgair
Beginner
Joined: 10 Nov 2000
Posts: 24
Location: USA
|
 Posted: Mon Mar 31, 2003 2:13 pm
occurances in a list
|
was just curious if there was a way to search through a list variable and return the number of occurances of a particular string
for instance if i have
A rock|A kid|A kid|A Bear|An Orc|A troll|A kid
and i want to know how many times each item in the list appears so i could get a result like
1-A rock 3-A kid 1-A Bear 1-An Orc 1-A troll
any suggestions on how i might do that?
Morgair, Master of the Obvious |
|
|
|
|
LightBulb
MASTER
Joined: 28 Nov 2000
Posts: 4817
Location: USA
|
Posted: Mon Mar 31, 2003 4:56 pm
|
%countlist() function. It's in the Function Reference under Database functions.
LightBulb
Advanced Member |
|
|
|
|
|
|
|
