topic Unable to Check Exist with case independent text in Product Forum

Unable to Check Exist with case independent text

ParnabSinha_Cho — Thu, 15 Dec 2022 12:09:04 GMT

Hi,

I have process where I am entering a text in a search box in a web page. Based on the search result I need to see if the entered text gave any search result or not. I am trying to use check exist, but if the search result is in a different case than the original text then the check exist fails. There could be multiple search result so the exact position can not be determined. Is there any way we can do a case independent Check Exist. I tried using Upper and Lower function but the search result can be in uppercase, lowercase or mixed case hence it fails.

Example -

Search Text - psc100

Search Result - PSC100 - Check Exist fails.

Search Text - PSC101

Search Result - psc101 - Check Exist fails.

Any suggestions will be great

Re: Unable to Check Exist with case independent text

PvD_SE — Thu, 15 Dec 2022 13:51:26 GMT

Hi Parnab,

If nothing real dynamic will be presented here, I'd try if you can first check for 'psc100' and if that fails, to check again but now with 'PSC100'. I assume the mixed case you mentioned would be 'Psc100' and not 'pSC100', in which case the 'Psc100' could easily be added to the list of valid values to check.

That said, I have seen dynamic searches using multiple search argument values, delimited with a semicolon (;). But this could be in another context than would suit yours as I could not find a ready example in my memory.

Happy coding!
---------------
Paul
Sweden

Re: Unable to Check Exist with case independent text

ParnabSinha_Cho — Tue, 28 Mar 2023 06:57:52 GMT

Hi, We have used regex in check exists and able to do a case independent search. This solved the mixed case issue. Thanks, Parnab