It's an SQL backend. We're on RemedyOnDemand v8.1. We need to fix the data before we import it into the People form.
On Fri, Apr 22, 2016 at 11:05 AM, Thomas Miskiewicz <tmisk...@gmail.com> wrote: > Is this about fixing the data or implementing a case insensitive search? > What database are you using? > > Thomas > > > On 22 Apr 2016, at 10:20, Satya Miller <only1sa...@gmail.com> wrote: > > > > ** > > Morning! > > > > I was hoping someone has an idea to help me with something. I have a > form that has two fields (First Name and Last Name) in it. The data is not > "clean." I need to convert the data in these two fields to Proper Case. > In other words, capitalize each word, or if possible even Capitalize > correctly like O'Connell. I searched the ARSList and the last suggestion > was from 2005. I was hoping there might be a better solution now. > > > > Thanks in advance for you help. > > _ARSlist: "Where the Answers Are" and have been for 20 years_ > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > "Where the Answers Are, and have been for 20 years" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"