Filter

[Malhar]

Hii,

I want to filter my data in a column.

For eg. I need to show only “not found” data, but when I do that, it searches for “not” differently and “found” differently. Hence, as a result I get the data which has “not” in it, and “found” in it.

Can anyone help?

[mruehl]

Maybe you can try *not*found*

[tresesco]

Try putting single quotes around your search string, like: 'not found' or with double quotes for cases insensitive search, like "Not fOUND".

[Malhar]

Hii,

thanks for your response. i tried but it did not work.

will the trim(not found) work?

thanks 🙂

[Malhar]

Hii,

thanks for your response, but it did not work.

will trim('not found')work?

thanks.

[tresesco]

Hi @Malhar ,

Try to explain a bit more about your context, where and how exactly you are trying to do. Then it become easier for us to guide you.

[Or]

Searching for "Not Found" will search for the explicit string "Not Found" and will not return hits on "Not" or "Found" individually.

[Malhar]

As you can seen in the picture, the colum named ‘Meldungslangtext’ include information “Reklamation nicht gerechtfertigt”. And I only want to see the data which contains this information.

How can I do that? 

[Or · Accepted solution]

Exactly as has been posted in this thread - you search for “Reklamation nicht gerechtfertigt” (or perhaps “*Reklamation nicht gerechtfertigt*” if this might not be the start/end of a word).

[Malhar]

Hii,

thanks a lot, it worked.

😀