This content has been marked as final. Show 2 replies
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...