Count : value auto-populated in a multivalued lookup field

[Former Member]

Hi,

Here is the context.

-

---

Every Item in the Products table has a Category and a Gift Type.

Gift Type is a multi-valued, text field that's calculated based on Category to Gift Type mapping in the Category Taxonomy. Every Category can map to multiple Gift Types.

Here is the problem.

-

---

When the values of Gift Types are calculated and auto-populated, I see that there is an extra Count: value being populated in the Gift Types field. This count reads 1: if there is just one mapped Gift Type and 3: if there are 3.

Question.

-

---

Is there a way to get rid of this counter?

I see this counter value when trying to fetch data from MDM using Java APIs as well.

Your help is appreciated.

Thanks

Anshuman

[Former Member]

Hi Anshuman,

don't know whether you solverd your problem already, but I ran into the same problem. My way of getting rid of the format 1:XXXX; is to use the following expression:

mid(<field_name>,3,len(<field_name>)-3)

Maybe that helps.

Christian