Filter on specific values which begin a string value

[cfine]

I am trying to filter on string data so it will return values which begin with any of the following numbers

110

120

121

130

140

141

The entire string value may look like 110200000000.  I have attached a list I need to filter off of.

Thank you

[JosephSerpis]

Hi @cfine I mocked up a workflow that produces the output you describe. Let me know what you think?

[cfine]

This is good, but what if I have more than 16 values I need to append?  I have 25 total values I need to look up.  Thank you

[JosephSerpis · Accepted solution]

Hi @cfine I adjusted the append tool and changed to allow all appends see the attached.

[vmartinez]

Hi @cfine,

Please find attached a workflow with 2 solutions. One in case your list of codes is small. and a second one in case the list of codes (110, 120, etc) is very big

Let me know if you have any questions

Best,

Vianney

[cking6178]

Maybe I'm missing something, but this seems like a pretty straightforward case to use Left with OR statements...similar to what @JosephSerpis provided. Is there something else you're looking for @cfine ?