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