Strip the Pipe Character (|) Out of a Value

In non-exlusive choice questions, you might see the "pipe" or | character in a text string. You can create a variable to remove it. #Results

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?