Pipe character in text values not escaped, affects filtering

Sam shared this question 41 days ago
Answered

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.

"City Administrator"

/15eb4284f8544c497765c5420244fa15

"City Administrator|Sustainability"

Here the value is double-counted.

/c6c1761f88ba678c39da7567a91b89b6

"Sustainability"

/d421e4a4ad81c1d35a34549bcfc9c955


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.

Comments (2)

photo
2

Hello Sam,

Thank you for submitting this. I'm working on getting replication steps together and will get this over to the product team for a fix. I will keep you posted on progress.

Thank you for letting us know!

David

photo
3

Hello Sam,

There is a bug fix request in place with the product team. We will keep you posted with updates as we have them.

Please let us know if there is anything else we can help you with.

David