Satya, If this is a one off, then use something like Excel and use the PROPER function. If you are getting a feed, the spoon tool have handy functions that should allow what you're looking for. If you absolutely must do it within Remedy, its doable, but more work to get that done. You probably could use a combination of substrc, lengthc, replace and upper to pull that off. I'd avoid that if possible.
From: Satya Miller <[email protected]> To: [email protected], Date: 04/22/2016 10:21 AM Subject: Proper Case Sent by: "Action Request System discussion list(ARSList)" <[email protected]> ** 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"
