Filter Values that start with a number

[tanishmittal]

Hi, I have a list of string values of which I want to filter the ones that start with 5. What's the workflow for the same, please help. Thanks!

[rkapoor · Accepted solution]

@tanishmittal I have attached a sample workflow for you.

You can use the "startswith" function.

[Seba]

Hi! What if I want to filter out by those that starts with a number?

do I have to use same formula + OR and include "1" trhu "9"?, like so:
Startswith([Field1], '1')
OR
Startswith([Field1], '2')
OR
Startswith([Field1], '3')
OR
Startswith([Field1], '4')
OR
Startswith([Field1], '5')
OR
Startswith([Field1], '6')
OR
Startswith([Field1], '7')
OR
Startswith([Field1], '8')
OR
Startswith([Field1], '9')