AnsweredAssumed Answered

RightValues inserts carriage return at end of result?

Question asked by BobSchwenkler on Nov 30, 2010
Latest reply on Nov 30, 2010 by BobSchwenkler

Title

RightValues inserts carriage return at end of result?

Post

Hi All, I'm having an issue with a calculation I'm working on implementing.

Example Calculation: LeftValues(inventoryIDs;1)&RightValues(inventoryIDs;ValueCount(inventoryIDs)-2)

If inventoryIDs=AP01¶BH01¶AD02¶BB01¶BB02, the above calculation returns AP01¶AD02¶BB01¶BB02¶.

The left values also seems to include a carriage return at the end of its value, but it doesn't pose a problem in this situation.

Is this how this function is supposed to work? I can include a ¶ stripping at the end of the calculation, but it seems like if I'm not asking for a carriage return I shouldn't be getting one.

Outcomes