Formala For MID

[sgaryali]

Hi

I want to keep the data as it for in Sector column for Location which has :-

ABC
CAT
BTR

in their location name and for

MAT

I want to change it to false. In excel we can achieve this by MID formula. But how to get it done in Alteryx?

[binuacs · Accepted solution]

@sgaryali one way of doing this

[Matthew]

 regex formula can do it fairly well

REGEX_Match([Location Name], ".*ABC.*||.*CAT.*||.*BTR.*")