[AccessD] Strip out text

Mark A Matte markamatte at hotmail.com
Tue Apr 4 11:10:28 CDT 2006


Hello All,

I have just recieved a new db to link to...and I want to create a dictionary 
for all of the wonderful acronym names used.  I have a list of field names 
in each table.  The format is the same across the board: BB_CREG_TU  or 
TTT_PROG_GYU_FRWTG (format= some letters...an undersore...more letters...and 
so on)

The can be 1 - 4 underscores in each name.  I would like to take this list 
of field names and strip out each part and create a new list.  For the 
example above I would now have 7 records...starting with BB and ending with 
FRWTG.  The underscore is always the seperator.  Any suggestions/direction 
would be greatly appreciated.

Thanks,

Mark A. Matte





More information about the AccessD mailing list