How filter values which is in capital letter or include any number

[Sshasnk]

I have a dataset and I have select the string which is in capital letter

Value

HUL1

sakish

HALBS

123

from the above, I only have to pick the third line. which is all in a small letter.

Output:

Value

sakish

[Emil_Kos]

Hi @Sshasnk,

The answer would be using regex. The first filter removes capital letters and second removes numbers. 

[AngelosPachis]

Hi @Sshasnk ,

You can do that with a filter tool using the following expression

REGEX_Match([Value], "\l+","icase=1")

[Ben_H]

Hi @AngelosPachis,

Just thought I'd point out that the formula you've used there is incorrect -

You have used REGEX_Match([Value], "\l+","icase=1")

You should only include the integer 1 or 0, not a string - for some reason putting any string at all there is treated as a 0 (i.e. Exact match) 1 would ignore case. It should read REGEX_Match([Value],"\l+",0)

Regards,

Ben

[AngelosPachis]

Hi @Ben_H ,

You are right, I missed changing that and I was lucky that it played in my favour. The expression should be REGEX_Match([Value], "\l+",0)

Thanks for raising that

[grazitti_sapna]

Hi @Sshasnk , please refer to the screenshot below.

Filter- REGEX_Match([Value], "\l+","1")

Thanks.

[RolandSchubert]

Hi @Sshasnk ,

you could use a Filter tool with condition:

MD5_ASCII([Value]) != MD5_ASCII(Uppercase([Value]))

comparing the string with the uppercase version of the string (the MD5_ASCII function is needed, as "=" usually ignore upper-/lowercase).

Let me know if it works for you.

Best,

Roland

[atcodedog05]

Hi @Sshasnk 

Using this formula in filter tool should work.

REGEX_Match([Value], "\l+",0)

Output:

Workflow:

Hope this helps 🙂