Saved Search String Contains filter : Searching for Underscore _ character.

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

Intermediate Asked on October 7, 2019 in SuiteAnalytics.
Add Comment
1 Answer(s)
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.

RE: Saved Search String Contains filter : Searching for Underscore _ character.

Beginner Answered on October 7, 2019.

Thanks, this worked for me. Is there a reason for the [  ]   around the underscore character? Seemed like I got mine to work without those.

on October 8, 2019.

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.

on October 8, 2019.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Limebox   Become a Sponsor