AnsweredAssumed Answered

Value List from Field  - clean up

Question asked by margotjacqz on May 11, 2012
Latest reply on May 11, 2012 by philmodjunk


Value List from Field  - clean up


There are a number of spots where I use a value list based on field contents - titles for example. Mostly they work as expected - each item once - but occassionally the list contains multiples of the same term. For example:

Director of Business Development
Director of Client Services
Director of Design
Director of Design
director of design
Director of design Strategy

Not to mention, I am pretty sure that I have more than three "Director of Designs."

A good chunk of this data was imported from somewhere else, so I expect that has something to do with it. Is there any way to force it to merge duplicates, inclduing different cases? Otherwise, it's a pretty tedious find and replace process.