What criteria can I put into the saved search to s...
# general
n
What criteria can I put into the saved search to search for items that contain a line break in the description? We have a script that's breaking when there is a line break in the item description. I need to find how many of such items we have in the system. But first, I need to figure out how to set a filter to look for such items in the saved search. Any ideas?
g
CASE WHEN INSTR({description}, CHR(13)) >0 THEN 1 WHEN INSTR({description}, CHR(10)) >0 THEN 1 ELSE 0 END
message has been deleted
n
Thank you, Gregory. Let me try that!
g
No problem. I'd suggest spot checking the results. Not sure how many items you have in your system. I'd also try the reverse and set the formula to look for 0, to see if items come up without linebreaks.
👍 1