RightValues inserts carriage return at end of result?
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.