Skip to Content
0
Former Member
Sep 13, 2007 at 08:44 PM

Splitting and Count Elements in an Array Field

92 Views

Post Author: siweltj

CA Forum: Formula

I have a SQL field that contains data such as described below:

"AM1,CS1,XW1,LR1" or any combination of these in any order

I want to count each of these variables independently. Such as a count of all "AM1" and a count of all "XW1" When using the Split function I get "The result of a formula can not be an array."

Can anyone steer me in the right direction on a solution? Thanks