use FIND but also limit the number of characters for boolean

CCOLMANT
CCOLMANT
in 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:

Answers

  • Ashutosh
    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.

    Ashutosh_1-1635939292983.png

     

     

     

     

  • Akhtar.shahbaz
    Akhtar.shahbaz

    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

Categories