Arrays and Fulltrim having issues with 0 values

HCL Domino Domino Forum
1

Hello All,

How can i empty a specific value in a multivalue field with empty string not 0 values

I have two fields with multivalues.

field

Name: PName----Name: PRates

product1------------60

product2------------0

product3------------50

product4------------0

product5------------40

product6------------0

I want to remove product2 and the corresponding rate 0 only.

If I use this formula, its working fine for product but not for Rates

Prn = doc.PName

Prn(2) = “”

doc.PName= FullTrim(prn)

prra = doc.PRate

prra (2) = “”

doc.PRate= FullTrim(prra)

the outcome is coming like this which is wrong

product1----------60

product3----------50

product4----------40

product5----------

product6----------

I know using fulltrim will remove 0 also.

How can i get the proper values by removing only empty values not 0?

Can someone please let me know.

Thanks

sri

2

Subject: Arrays and Fulltrim having issues with 0 values

Thansk Dan.

Will try that.

3

Subject: Arrays and Fulltrim having issues with 0 values

Only a suggestion, but maybe you could replace the 0 values with something else first (something that would never exist in the field), remove the relevant array member, fulltrim and then replace the values with 0 again

There may be a better way of doing it of course…