2 Replies Latest reply on Nov 30, 2010 12:40 PM by BobSchwenkler

    RightValues inserts carriage return at end of result?

    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.