I have a field that can return multiple values with everything surround by ampersands. So if it just returns one value I get &AAA& if I have two values I get &AAA&BBB& and so on.
Is there a way to get the field to return separate values and remove those ampersands?
Thanks