use FIND but also limit the number of characters for boolean

CCOLMANT
Occasional Contributor

use FIND but also limit the number of characters for boolean

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 !

 

2 REPLIES 2
Ashutosh
Occasional Contributor

Hi,

 

You can use MID Function. Please find below SS:

You can see, if it not starts with 'S' it will show blank. Hope this will solve your issue.

Ashutosh_1-1635939292983.png

 

 

 

 

Akhtar.shahbaz
Community Boss

Hi @CCOLMANT ,

 

Is your requirement to find the store code starting with "S"& no of character <= 4 then you can try below:

Screenshot_254.png

Screenshot_255.png

 

Hope this helps

Thanks

Akhtar