Solved
Filter for values that contain line breaks
I'm trying to find records that contain a line break when they shouldn't. The field I'm trying to filter is a text field. How can I do this? To be clear, I'm trying to do this purely in the front-end...
Welp, nevermind...right after posting this, I figured it out on my own. Sheesh.
Well, I guess for anyone else who's come to this post via the search and are trying to do the same thing, here's what I did:- Add the filter to the widget for the field in question
- Select the Text tab. Make sure the dropdown is set to Contains logic, then type "\n" in the input box.
- Switch to the Advanced tab. You should see the following: "contains": "\\n"
- Remove the second slash from within the second set of quotes, so you end up with this: "contains": "\n"
- Click OK
This should filter down to only the records where the field contains a line break. You can verify this by including some other filter that makes it so your result set has both records with a line break and records without one, then toggle the first filter on-and-off. You'll see the no-line-break records get filtered out appropriately whenever the filter is active.
