Matching first character to an Alphabetic list

[jarbro]

I have been tasked with segmenting our customer database alphabetically.  I have certain territories which require any customer organization whose name starts with A-M go to one employee and N-Z to a second one.

 

If the Organization = Bluefish Industry and it matches any character within the list "ABCDEFGHIJKLM"  

I would like it to return 0 or 1.

 

I would also like to be able to handle stripping out any articles in the event the corporation name is 

"The Bluefish Industry"

 

I was looking at using PatternCount (Left(company_name;1); "ABCDEFGHIJKLM") however I don't believe I have it formatted correctly.

 

 

Any ideas?

[comment]

You've got it backwards - it needs to be =

PatternCount ( "ABCDEFGHIJKLM" ; Left ( company_name ; 1 ) )

I would also like to be able to handle stripping out any articles

 

Are there any articles other than "The" that would qualify?

[jarbro]

The is the only article to filter.

[comment]

Ok, so how about =

Let ( [
art = LeftWords ( company_name ; 1 ) = "the" ;
word = MiddleWords ( company_name ; 1 + art ; 1 )
] ;
Left ( word ; 1 ) > "m"
)

[comment]

Or, if you prefer =

...
] ;
word ≥ "n"
)