use FIND but also limit the number of characters for boolean

[CCOLMANT]

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 !

[Ashutosh]

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.

[Akhtar.shahbaz]

Hi@CCOLMANT,

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

Hope this helps

Thanks

Akhtar