[SOLVED] Universe dictionary item extract first character of attribute in a multivalue field

Universe dictionary item extract first character of attribute in a multivalue field

am trying to extract the first character from each subvalue in a record attribute.

Thus far am trying

REUSE(@RECORD<2>);FIELD(@1,'*',1,1)

But it would appear to be returning the first character of the first subvalue.

Know this can be done, but having no luck with it.

Edit record 2 is in the format ABC]BAD]FCC"

Edit 2 , sorry there's an aster (*) between each letter of the array in previous line but can't work out how to show that

Solution

If it you are looking to do a FIELD operation on a multivalued attribute use FIELDS instead.

FIELDS(@RECORD<2>,'*',1)

If you are trying to get just the first character, or so any kind of string manipulation for that matter, I will tell you that I have long found that to be somewhat difficult. Upon reflection, the way forward might be using FMTS(), but as I am not sure that is what you are looking for, I will wait to test that out when I have need for it again.

Good Luck.