Filter using wildcard "%"

Hi i'm trying to use Alteryx to only keep rows where a string field starts with a particular sequence such as the following:

XYZ1

XYZ2

XYZ3

etc.

But i do not want it to keep rows where the string field contains XYZ but XYZ is not first 3 letters.ex:

123XYZ1

twfXYZ2

I think the SQL code is equal to using "XYZ%" but i wasn't able to utilize this in Alteryx. It's probably something simple i'm overlooking. Any chance someone knows how to overcome this?

Thanks for your help!

Preparation

Accepted answers

MarqueeCrew

@treehook,

Here are a couple of ways:

Left([String_Field],3) = "XYZ"
&&
Length([String_Field]) > 3

Regex_Match([String_Field],"XYZ.+")

Cheers,

Mark

Claje

Another option is the STARTSWITH() function.

If you ran

STARTSWITH([String_Field],'XYZ')

This will do exactly what you are looking for.

Essentially:

STARTSWITH = SQL LIKE 'XYZ%'

CONTAINS = SQL LIKE '%XYZ%'

ENDSWITH = SQL LIKE '%XYZ'

All comments

treehook

To clarify, I'm needing this for a formula tool so it's the syntax to write this. Thanks!

MarqueeCrew

@treehook,

Here are a couple of ways:

Left([String_Field],3) = "XYZ"
&&
Length([String_Field]) > 3

Regex_Match([String_Field],"XYZ.+")

Cheers,

Mark

Claje

Another option is the STARTSWITH() function.

If you ran

STARTSWITH([String_Field],'XYZ')

This will do exactly what you are looking for.

Essentially:

STARTSWITH = SQL LIKE 'XYZ%'

CONTAINS = SQL LIKE '%XYZ%'

ENDSWITH = SQL LIKE '%XYZ'

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703