Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
How can I search without using a wildcard ( *,~ or others )? for example, if I search y, 0,3,p,s I can't see the result, because is not the first letter. Only the first letter return search, is it possible to return a search with any letter independent of the first or not?
You need to use wildcards for searching parts withing a string
Or
You can use advanced search using string functions like substringcount() , index() ,findoneof() or even wildmatch()
=Substringcount (ID,'y')
Or
=Index(ID,'y')
Or
=Wildmatch (ID,'*y*','*0*')
You can refer to help section for more on these functions