Searching star symbol

[#1]

Hello!

I hope for your help. How can I search for names with "*" symbol?

[sivarajs]

* helps you to search specific string

Example:

*a - filters string begins with 'a'

*word*- search for particular string

a*- filters string ends with a

[#3]

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

[tresesco]

Try like:

=If(FindOneOf(YourField,'*'), YourField)

[#5]

User should be able to search such values in Search object

[#6]

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

[arjunkrishnan]

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

[#8]

Thanks a lot, but I'm trying to ask another question

[mangalsk]

Hello,

Try this it works

=if(Index(field1,'*')>=1,field1)

[ThornOfCrowns]

OP knows this, but is asking for ahow to search for a * in text.