Contains and Startswith not working?

[Bobbins]

Simple text:

Field1	Result
Slate	1
SLATE	1
SLATE:	1
SLATE: THIS IS ANOTHER TEST	0
SLATE V2	0
SLATE V3	0

Formula:

IF 
Startswith("SLATE:",[Field1]) then 1 elseIF 
Contains("SLATE",[Field1]) then 2 else
0 endif

Why are the bottom 3 rows still giving 0 for? 

Thank you. Packed workbook included

[JosephSerpis · Accepted solution]

Hi @Bobbins you need to swap the arguements in your contains statement for it to work.

IF 

StartsWith("SLATE:",[Field1]) then 1 elseIF 
Contains([Field1],"SLATE") then 2 else


0 endif

[MarqueeCrew]

@Bobbins ,

So many varieties in your potential data, wouldn't you like to use a single function (set)?

UPPERCASE(GetWord([Text], 0))

Now you have a standardized view of the first word.

Here's a way to do this that is unique and (hopefully) easy to understand:

Switch(UPPERCASE(GetWord([Text], 0)),0,"SLATE:",1,"SLATE",2)

The default is 0

When it is SLATE you get 1

When it is SLATE: you get 2

Cheers,

Mark

[Bobbins]

@JosephSerpis I could have sworn i tried it the other way and it didnt work. Sorry. stupid error

@MarqueeCrew I am actually using case to define what words I do and don't need in this instance. I had not realized  "switch" was available to altreyx so thank you for the lesson!