2 Replies Latest reply on Jul 18, 2018 10:05 AM by Catherine March

    Unable to search or filter on text containing '&'

    Catherine March



      I have string field that contains an ampersand and other alphanumeric characters (ex: A&W Rootbeer). Prep does not allow me to search a field that contains an '&' and it cannot be found using a formula either.


      In the summary tabs, fields with '&' are listed:

      But the search field returns no results:

      Similarly, the formula searches for like names and bundles them together:

      And the result contains everything except the fields with an '&':


      Looking for a workaround or confirmation that this is just a bug in Prep...