Tracing the first number in an alphanumeric code.

[Satyaki04]

I have records with string as data type. I would need to find out cases where the record starts with "0". 

I want to use Custom Filter to track this. Thanks for your assistance.

[ganesamurthy]

I doubt if you can acheive this with only Filter tool, rather I would go for a Regex tool or Formula tool, then combine with Filter tool to acheive this result.

[benakesh]

Hi @Satyaki04 ,

Try left function . You can use this in filter  :  left([field],1) = '0'  

[Satyaki04 · Accepted solution]

Thanks for guiding me.

I have proceeded as below:

left([WBS NUMBER],1)!="0"

This has helped me to group cases starting with "0" under false category.

[Satyaki04]

Thanks for guiding me.

I have proceeded as below. 

left([WBS NUMBER],1)!="0"

This has helped me to group all cases under False which start with "0".