Separate line item by first number

Question

Hello,

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

Serial # 565654678976234245456437487898578678564565423423786878476879

Thank you

kauser

CoG · Accepted Answer

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!