Doubt with searching values

[#1]

Dears,

I have a field, colled Description, and I would like to search for everything that contains L1 and do not contain L2.... how can I do it?

There is no simple behaviour, once it is a text descriptions!

I've tryied something like "=L1" "<>L2" But it didn´t worked!

Thanks per your attention,

Best regards

[MayilVahanan]

Hi

Description contains??

For search, simply gives *L1*

can you explain it in more details?

[Miguel_Angel_Baeyens]

Hi,

If you mean in the same string one char but not another one, try this:

='(' & Concat({< Name = {"J*"} - {"*l"} >} Name, '|') & ')' 

In this case, will select all names that start with J and not end with lowercase L. Chech the app attached.

Hope that helps.

Miguel

[#4]

Dears,

I would like to search for results values that contains "L1" written anywehere of the line, and do not contain the word "L2" written.

Thanks per your assistance,

Best regards

[#5]

Where should I put it?

[Miguel_Angel_Baeyens]

As in the app attached,

Create a new button, go to the Actions tab in the button properties, add a new action, type Selection, Select in Field, set the field name and the expression above as the search string.

Hope that helps.

Miguel

[#7]

Thanks a lot per your attention,

But it didn´t worked!

Imagine I have the following data

L1 Inspection

L1 Ins

L1 Main

L1, L2, L3

L1, L2 Inspections

L2, L1 Inspection
L2 Inspection

L2, L1 Insp

...

I would like to have something showing me, as result of my search, the following values:

L1 Inspection

L1 Ins

L1 Main

How can I do it?

Best regards,

[Miguel_Angel_Baeyens · Accepted solution]

Hi,

Yes, it does work. Check attached.

Regards.

Miguel