use FIND but also limit the number of characters for boolean

Options
CCOLMANT
CCOLMANT Member, ALL USERS Posts: 5 Occasional Contributor
in Planning & Modeling

I have multiple store codes that are not within my perimeter and I am trying to create a boolean that reads the start character "S"  

 

I managed to reduce the list but still need to reduce it saying that the code starts with "S" but the character count limit is 4. 

 

SJ5
SJ6
SJ7
SI5000002
SI5000003
SI5000004
SI5000005
SI5000006
SI5000007
SI5000008
SI5000009
SJ8
SJ9
S60
SB1

 

I want to be able to ignore items that are not within a 4 character count limit (example above)

 

Thanks !

 

Tagged:

Categories