Gossamer Forum
Home : Gossamer Threads Inc. : Custom Modification Jobs :

DBman Request - Custom Replace for Field Contents

Quote Reply
DBman Request - Custom Replace for Field Contents
 
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
Quote Reply
Re: DBman Request - Custom Replace for Field Contents In reply to
Seems that an easy fix would be just to create another table with two fields one for the code and another for the definition of the code and adding a relationship between the tables.