Filter the file where 3rd and 4th characters are 1 and 0 respectively

[manjarigoyal]

I have a file where Field A values are alphanumeric. I need to filter the file where 3rd and 4th characters are 1 and 0 respectively. I am not sure how to do it. I have 10000 records.

Field A

CL07XC058

SA10XC070

CL34XC010

The true should have CL07XC058 and CL34XC010 but false should have SA10XC070. Appreciate any help.

Thanks

[patrick_digan · Accepted solution]

@manjarigoyal in a filter tool, try: 

substring([Field1],2,2)!="10"

Remove the ! if you think the T and F are mixed up.

[Garrett · Accepted solution]

Substring([Field A],2,2) NOT IN ('10')