RE: Saved Search String Contains filter : Searching for Underscore _ character.
Answered
Can anyone suggest how to have a search Filter utilizing Contains Operator against a string field which contains an underscore?
Just using normal method does not work since underscore _ is applied as a special character. (see pg 25 of https://docs.oracle.com/cloud/latest/netsuitecs_gs/NSSRC/NSSRC.pdf for reference)
Thanks
Best answer
I don’t think you can find “_” directly in the saved search criteria by using contains. But, you can create a formula(Text) filter name in the criteria, and then use a formula to first find the records having underscore and then replace underscore with any unique char. At last, look for the records containing that special character. You should be able to perform all those steps in a single statement. Please see the below screenshot for the reference.
Thanks, this worked for me. Is there a reason for the [ ] around the underscore character? Seemed like I got mine to work without those.
Great!! The square bracket was added just to make sure there’s an exact match. If it worked w/o for you then that’s right too.
