Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I need to find a way to create a Filter that contains certain words of a determinate Field.
For example: I have this list box of the field "Model"
I want to create some filters that filter the data depending on the words:
I would be very grateful if someone help me.
Thanks in advance.
Martín
Martin,
Can you please provide the clear screenshot of this example as the provided One is not attached properly.
Or
You can use search option in the properties by using *bom* like that.
Gopi.
The image seems to be broken for me, would you be able to repost the image to see what you are looking to get?
Hi Gopi,
Here's the image:
Hi Sunny,
Here's the image:
I am guessing this:
if(Match(yourfieldname,"Bom", Excelente")>0 ,yourfieldname) as yourfieldname
Same for others
if(Match(yourfieldname,"Blackberry", "Samsung")>0 ,yourfieldname) as yourfieldname
Is the words consistent? First part seems to be the Brand Name but again iPad2 is not a brand name. You can use strings functions to break the field like subfield() but you need to be careful of the consistency of the data
I want to finally have something like this that work as list box to filter the results:
The Condition is not a Field. Bom and Excelent are just words inside the Field "Model".
I want to find a way to create that kind of list box which filter that words in the results without modifications in the original file.
I want to finally have something like this that work as list box to filter the results:
The Condition is not a Field. Bom and Excelent are just words inside the Field "Model".
I want to find a way to create that kind of list box which filter that words in the results without modifications in the original file.
I want to finally have something like this that work as list box to filter the results:
The Condition is not a Field. Bom and Excelent are just words inside the Field "Model".
I want to find a way to create that kind of list box which filter that words in the results without modifications in the original file.