Create Filter using words of certain Field

[#1]

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:

• One that contains "Bom" or Excelente"
• One that contains the brands as "Blackberry", "Samsung",etc.
• One that contains the models "iPhone 5, "Z30", etc.

I would be very grateful if someone help me.

Thanks in advance.

Martín

[sergio0592]

Or this :

=if(Fieldsname like '*iPhone 5*' or Fieldsname like "*Z30*" ,Fieldsname,null())

[#3]

Yes, are consistent. For example, all the models have attributed a condition, "Bom" or "Excelent".

There is any way to do the last picture? That list box filter with the condition.

[Anonymous]

See if this is:

Find Key Words and Phrases in Free Text Fields

[#5]

Thanks Marcio, but no.

What I need to create is this (I made it with paint):

[Anonymous]

These conditions are fixed?

If so, you can create a InLine with the conditions, and make the search as the item sent.

[Conditions]:

LOAD * INLINE [

  Condition

  'Bom'

  'Excelent'

  ];

[#7]

Marcio,

Thanks to that I managed to create the Field "Conditions" and the Listbox but when I clicked in some condition is not working as a filter of the results, I clicked and nothing happens.

[Anonymous]

Try this j j:

[#9]

Marcio,

Works great, thanks!

The only problem is:

In LOAD * Inline [

  Name 

Have I to list all the devices? Because I have more than 1500...

[Anil_Babu_Samineni]

Do You mean this??

Script

LOAD Field, SubField(Field, ' ', -1) as Field1;

LOAD * Inline [

Field

Blackberry 9900 Seminovo Bom

Blackberry 9900 Seminovo Excelente

Blackberry 9900 Seminovo Muito Bom

Blackberry Q10 Preto Seminovo Bom

Blackberry Q10 Preto Seminovo Excelente

Blackberry Q10 Preto Seminovo Muito Bom

ipad 2 Wi-Fi + 3G 16GB Branco Seminovo Bom

ipad 2 Wi-Fi + 3G 16GB Branco Seminovo Excelente

ipad 2 Wi-Fi + 3G 16GB Branco Seminovo Muito Bom

ipad 2 Wi-Fi + 4G 32GB Branco Seminovo Bom

ipad 2 Wi-Fi + 4G 32GB Branco Seminovo Excelente

ipad 2 Wi-Fi + 4G 32GB Branco Seminovo Muito Bom

];

For Ref, PFA. Now tell me what is the Issue? Make sure if anyone reply is useful please mark as Helpful. If you are happy that Close This Thread by Flag Correct Answer

[#11]

Hi Martin

               you can use below function to get desire o/p:

               subfield('Blackberry 9900Seminovo Bom', ' ' ,-1)