Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello!
I hope for your help. How can I search for names with "*" symbol?
* helps you to search specific string
Example:
*a - filters string begins with 'a'
*word*- search for particular string
a*- filters string ends with a
I think you got me wrong. First of all you probably have a typo
*a - ends with a
a* - begins with a....
But I want to find the words with "*" symbol inside. For example I have value like "15*3", where * means multiplication
Try like:
=If(FindOneOf(YourField,'*'), YourField)
User should be able to search such values in Search object
I have field that contains names of pipes. Values consist of diameter and cross-section.
For example "6*15" means pipe with 6 diameter and 15 cross-section
Hi Frd,
Star(*)
* -> Star Symbol Is Use Searching The String Vale .It's Work Like Literally Like Operation in Sql We Will User This
Working Procedure For *(Star)
Suppose I'm Searching Field Vale In Table
Eg():
ID Stud_Name
01 RamKumarNathan
02 RajKumar
03 PreamKumar
04 KarthiRaj
Now I Want To Show Stud_Name "Kumar"
In Sql .....Where Stud_Name Like(% Kumar %)
In Qlik View ...... Where WildMatch(Stud_Name,'*Kumar*')
Result
ID Stud_Name
01 RamKumarNathan
02 RajKumar
03 PreamKumar
Now I Want To Show Stud_Name Start With R & K
In Qlik View ...... Where WildMatch(Stud_Name,'K*','R*')
Result
ID Stud_Name
01 Ram KumarNathan
02 Raj Kumar
04 Karthi Raj
Now I Want To Show Stud_Name End With R
In Qlik View ...... Where WildMatch(Stud_Name,'*R')
Result
ID Stud_Name
02 Raj Kumar
03 PreamKumar
I Think Now U Clear Idea About On Searching Symbol For Star
Thank You
ArjunKrish
Thanks a lot, but I'm trying to ask another question
Hello,
Try this it works
=if(Index(field1,'*')>=1,field1)
OP knows this, but is asking for ahow to search for a * in text.