The formula to remove the pipe character is:
=If(Right([OBJECT];1)="|";(Left([OBJECT];(Length ([OBJECT]) -1)));[OBJECT])
Broken down, this says:
If the rightmost character of the object is a pipe (= “|”)
Then calculate the current length of the object
Subtract 1 from that number (we’ll call this number “x”)
Now, starting with the leftmost character, return only “x” number of characters (basically saying “cut off the last one”)
If the rightmost character is NOT a pipe, then just show the whole object.