I am developing an online directory for an association of 270 not-for-profit, faith-based homeless shelters - http://www.agrm.org/missions/
The information for the directory comes from a plain text export out of our member management software, iMIS. Along with the normal contact information, there's a field that lists the types of services offered by each shelter, for instance "ED6" indicates that they have a progam for teaching "English as a Second Language". There's actually a list of about 50 different program codes (see - http://www.agrm.org/key.html )
The codes are all in a single field and look like this:
CH,CY1,DV1,DV2,ED1,ED2,ED3,ED6,FD1,ID2,MN1,MN2,MN4,RX1,SG,WF1,WF10,WF3,WF4,WF8
I would like to be able to replace the codes with the actual full text name of the programs and would also like to replace the "," with either "<BR>" or "<LI>".
After posting to the Forum, I understand that there is no way to do this with the standard DBman setup. So, we would like to contract with someone who could add this feature for us.
Michael Liimatta, Education Director
AGRM (http://www.agrm.org)
Kansas City MO USA