All Collections
ETO Results 4.3
Formulas and Objects
ETO Results | Formula: Strip the Pipe Character (|) From a Value
ETO Results | Formula: Strip the Pipe Character (|) From a Value

BO 4.3 Platform

Updated over a week ago

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.

Did this answer your question?