How to group strings by prefix

Posted by namenlos on Stack Overflow See other posts from Stack Overflow or by namenlos
Published on 2010-04-08T09:27:55Z Indexed on 2010/04/08 9:33 UTC
Read the original article Hit count: 499

Filed under:

grouping

|

names

|

prefix

I am writing a Winform UI in which the user must select a single customer. (For reasons beyond my control I am limited to a UI that uses dropdown lists, text fields, checkboxes, radiobuttons only -i.e. no fancy special UI controls)

The situation

There are a lot of customers (a thousand for example)
If i put all the customers in a single dropdown there's no way it will be easy for a customer to even see all the customers. Also the it will take too long to retireve all the customers from the DB to populate the dropdown
My thought is to have two combo box, the first lists groups of the customers by their last name something like a phone book "Aa-Ac", "Ad-Ade", "Adf-B", when selecting the first combo box, it scope the second one to a managable set customer names (no more than for example 40 names)

The question

I need a reasonable way of grouping their names such that it will be clear to customer which group contains the name. I.e. given a group of names I need to bucketize then int "Aa-Ac".

Comments

I don't need to solve the general problem of an immense number of names - we know based on our data that 1000 names is the max our users will encounter.
If there are other techniques please do share, but I am interested specifically in an answer to my specific question around how to determine the buckets ("Aa-Ac", etc.)

© Stack Overflow or respective owner

Related posts about grouping

Grouping every 3 items in xslt 1.0

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm having troubles to figure out a way to group items xslt 1.0. I have a source xml similar to the one below: <client name="client A"> <project name = "project A1"/> <project name = "project A2"/> <project name = "project A3"/> <project name = "project… >>> More
Introducing the Tablix Data Region: Basic Grouping Concepts

as seen on Internet.com - Search for 'Internet.com'
BI Architect Bill Pearson continues his examination of the general characteristics and properties of the Tablix data region, which debuts in Reporting Services 2008. Here, we discuss further concepts, and begin our hands-on examination of a Tablix data region in a working sample report. >>> More
Dynamic Grouping and Columns

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Some good collaboration between myself and Kan Nishida (Oracle BIP Consulting) over at bipconsulting on a question that came in yesterday to an internal mailing list. Is there a way to allow columns to be place into a template dynamically? This would be similar to the Answers Column selector. A customer… >>> More
Fastest way to group units that can see each other?

as seen on Game Development - Search for 'Game Development'
In the 2D game I'm working with, the game engine is able to give me, for each unit, the list of other units that are in its view range. I would like to know if there is an established algorithm to sort the units in groups, where each group would be defined by all those units which are "connected"… >>> More
Python: Improving long cumulative sum

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a program that operates on a large set of experimental data. The data is stored as a list of objects that are instances of a class with the following attributes: time_point - the time of the sample cluster - the name of the cluster of nodes from which the sample was taken code - the name… >>> More

Related posts about names

SmoApplication.EnumAvailableSqlServers returns server names but not instance names (but only on one

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, There are a number of questions about this and a number of possible causes and thus far ive tried them all with no success. situation: i have an app that needs a db to work, onstartup it does a SmoApplication.EnumAvailableSqlServers(false) to get all the instances on the network, shows the user… >>> More
MySQL Select names with last names ending with certain letter

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a MySQL database with a field Name which contains full names. To select all people with last names ending in a particular letter, let's say A for this example, I use the following query: SELECT * FROM db WHERE Name LIKE '% A%'. However, this also selects users who have a middle name starting… >>> More
Drilling into a drive and changing folder names & document names

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a drive on my computer that has folder--some of which have lots of folders w/in other folders and also contain files. I need to migrate these docs into sharepoint, however a LOT of these folders and files have invalid characters that will not allow me to migrate into sharepoint (i.e. " / \… >>> More
Table/column names enclosed in square brackets, even though their names consist of legal characters

as seen on Stack Overflow - Search for 'Stack Overflow'
Square brackets allow you to use names for columns or aliases that contain characters not permitted for column names or aliases. a) I’ve noticed that lots of times table and column names are enclosed inside square brackets, even though their names consist of perfectly legal characters. Why is that… >>> More
MySQL Select names with last names starting with certain letter

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a MySQL database with a field Name which contains full names. To select all people with last names starting with a particular letter, let's say A for this example, I use the following query: SELECT * FROM db WHERE Name LIKE '% A%'. However, this also selects users who have a middle name starting… >>> More