Pipe character in text values not escaped, affects filtering
I have a variable that readers can filter by that contains values like "City Administrator", "Sustainability" and a few combinations separated by a pipe like "City Administrator|Sustainability." I expect that latter combination to show up as its own value, because it's a unique text group for that field. But the "|" character is not getting escaped so those records appear when "City Administrator" or "Sustainability" are selected.
The pictures here should help clarify. Note the one record that is "City Administrator|Sustainability" showing up in the tables, but with an empty value for training group.
Here the value is double-counted.
Ideally the filtering would not apply any regex to my text values and could just display "City Administrator|Sustainability" as its own combination. If the software wanted to interpret the | as both, then it should not be appearing on its own blank row in the table, and should not be counted twice in the second table.
I will work around this by changing the | character to a dash during data ETL but wanted to report this bug.