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?

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?

The is the only article to filter.

Ok, so how about =

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

Or, if you prefer =

...
] ;
word ≥ "n"
)