Separate line item by first number

[kauser]

Hello, 

how can we separate/remove linen item that start with serial#4 from list below - 

Serial #
565654
678976
234245
456437
487898
578678
564565
423423
786878
476879

Thank you 

kauser 

[CoG · Accepted solution]

Filter Tool:

Left(ToString([Serial # ]),1) != "4"

^Assumed we are working with numerical data type. Thus, first convert to string, take the first character and confirm that it is not "4".

Happy Solving!