Re: Proper Case
As someone mentioned earlier, there are ways to do this in Pentaho. You could create a copy of the current staging form, and run a transformation that moves the data from one form to the other. In the transformation you can use the Calculator step. In this step there is a function called, “First letter of each word in a String A in capital. If you performed this function on the first name and last name fields as you migrated the data to the 2nd staging form it would make it proper case. Obviously there may be easier methods out there that won’t require moving the data twice before pushing to the People form just wanted to let you know of this step in Pentaho. -- View this message in context: http://ars-action-request-system.1093659.n2.nabble.com/Proper-Case-tp7603814p7603828.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Proper Case
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 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 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"
Re: Proper Case
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 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"
Re: Proper Case
We are using a web service to populate the staging form. We were going to correct the data in the staging form before we populated the people form. If there is a better way to correct the data using a web service before we populate the staging form I'd be most appreciative in hearing them! On Fri, Apr 22, 2016 at 9:55 AM, Kelly Logan wrote: > ** > The basics are simple, but there are some caveats to be careful of. > >1. Some names do not have only the first letter capitalized (McDonald, >BillyRae...etc). You may want to have an exception list to check against. >2. Last name hyphens and suffixes can be tricky as well. "Jr." is >fine, but you don't want to end up with "Chisholm-brickell" or "Whitelaw >Iii". > > It might be worth checking to see if there is a web service you could > consume that checks for these kinds of exceptions. Seems like someone > should have that out there by now. > > On Fri, Apr 22, 2016 at 10:39 AM, Rick Cook wrote: > >> ** >> >> You will have to sequence the string functions. Use one to identify the >> first character of each field, then another to ensure that the is upper >> case. Then the next one will ensure that the rest are lower case. >> >> Rick >> On Apr 22, 2016 7:35 AM, "Satya Miller" wrote: >> >>> ** >>> I could only find Upper and Lower. Nothing about Proper Case. >>> >>> On Fri, Apr 22, 2016 at 9:22 AM, Rick Cook wrote: >>> >>>> ** >>>> >>>> The string functions should be able to do that. Look in the appendix >>>> of your AR System documents. >>>> >>>> Rick >>>> On Apr 22, 2016 7:21 AM, "Satya Miller" 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_ >>>> >>>> _ARSlist: "Where the Answers Are" and have been for 20 years_ >>> >>> >>> _ARSlist: "Where the Answers Are" and have been for 20 years_ >> >> _ARSlist: "Where the Answers Are" and have been for 20 years_ >> > > > > -- > Kelly Logan > Senior Consultant > Rapid Technologies, Inc. <http://www.raptek.com> > Office: 313-651-7169 > Cell: 313-645-4552 > _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"
Re: Proper Case
The basics are simple, but there are some caveats to be careful of. 1. Some names do not have only the first letter capitalized (McDonald, BillyRae...etc). You may want to have an exception list to check against. 2. Last name hyphens and suffixes can be tricky as well. "Jr." is fine, but you don't want to end up with "Chisholm-brickell" or "Whitelaw Iii". It might be worth checking to see if there is a web service you could consume that checks for these kinds of exceptions. Seems like someone should have that out there by now. On Fri, Apr 22, 2016 at 10:39 AM, Rick Cook wrote: > ** > > You will have to sequence the string functions. Use one to identify the > first character of each field, then another to ensure that the is upper > case. Then the next one will ensure that the rest are lower case. > > Rick > On Apr 22, 2016 7:35 AM, "Satya Miller" wrote: > >> ** >> I could only find Upper and Lower. Nothing about Proper Case. >> >> On Fri, Apr 22, 2016 at 9:22 AM, Rick Cook wrote: >> >>> ** >>> >>> The string functions should be able to do that. Look in the appendix of >>> your AR System documents. >>> >>> Rick >>> On Apr 22, 2016 7:21 AM, "Satya Miller" 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_ >>> >>> _ARSlist: "Where the Answers Are" and have been for 20 years_ >> >> >> _ARSlist: "Where the Answers Are" and have been for 20 years_ > > _ARSlist: "Where the Answers Are" and have been for 20 years_ > -- Kelly Logan Senior Consultant Rapid Technologies, Inc. <http://www.raptek.com> Office: 313-651-7169 Cell: 313-645-4552 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Proper Case
If you are using oracle https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions065.htm As in Select initcap('$fullname$') from dual In a set - fields action. On Apr 22, 2016 9:39 AM, "Rick Cook" wrote: > ** > > You will have to sequence the string functions. Use one to identify the > first character of each field, then another to ensure that the is upper > case. Then the next one will ensure that the rest are lower case. > > Rick > On Apr 22, 2016 7:35 AM, "Satya Miller" wrote: > >> ** >> I could only find Upper and Lower. Nothing about Proper Case. >> >> On Fri, Apr 22, 2016 at 9:22 AM, Rick Cook wrote: >> >>> ** >>> >>> The string functions should be able to do that. Look in the appendix of >>> your AR System documents. >>> >>> Rick >>> On Apr 22, 2016 7:21 AM, "Satya Miller" 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_ >>> >>> _ARSlist: "Where the Answers Are" and have been for 20 years_ >> >> >> _ARSlist: "Where the Answers Are" and have been for 20 years_ > > _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"
Re: Proper Case
I would think if you’re looking for a remedy solution, the easiest thing would be set it all to LOWER first and then work out which letters need to be capitalised. The first letter is easy, then you want to find the location of a space character and UPPER the letter after that, and same again for O’… however Mc/Mac names are more tricky as some people are MacKay while others are Mackay for example. There is no failsafe way to do that. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Rick Cook Sent: 22 April 2016 15:39 To: arslist@ARSLIST.ORG Subject: Re: Proper Case ** You will have to sequence the string functions. Use one to identify the first character of each field, then another to ensure that the is upper case. Then the next one will ensure that the rest are lower case. Rick On Apr 22, 2016 7:35 AM, "Satya Miller" mailto:only1sa...@gmail.com>> wrote: ** I could only find Upper and Lower. Nothing about Proper Case. On Fri, Apr 22, 2016 at 9:22 AM, Rick Cook mailto:remedyr...@gmail.com>> wrote: ** The string functions should be able to do that. Look in the appendix of your AR System documents. Rick On Apr 22, 2016 7:21 AM, "Satya Miller" mailto: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_ _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ Glasgow - UK Council of the Year 2015 ***Disclaimer This e-mail and any attachments are for the intended addressee(s) only and may contain confidential and/or privileged material. If you are not a named addressee, do not use, retain or disclose such information. This email is not guaranteed to be free from viruses and does not bind Access in any contract or obligation. SERVICE GLASGOW LLP trading as ACCESS Registered in Scotland. No: SO301705 Registered Office: 220 High Street, Glasgow, G4 0QW ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Proper Case
You will have to sequence the string functions. Use one to identify the first character of each field, then another to ensure that the is upper case. Then the next one will ensure that the rest are lower case. Rick On Apr 22, 2016 7:35 AM, "Satya Miller" wrote: > ** > I could only find Upper and Lower. Nothing about Proper Case. > > On Fri, Apr 22, 2016 at 9:22 AM, Rick Cook wrote: > >> ** >> >> The string functions should be able to do that. Look in the appendix of >> your AR System documents. >> >> Rick >> On Apr 22, 2016 7:21 AM, "Satya Miller" 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_ >> >> _ARSlist: "Where the Answers Are" and have been for 20 years_ > > > _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"
Re: Proper Case
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 To: arslist@ARSLIST.ORG, Date: 04/22/2016 10:21 AM Subject: Proper Case Sent by:"Action Request System discussion list(ARSList)" ** 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"
Re: Proper Case
I could only find Upper and Lower. Nothing about Proper Case. On Fri, Apr 22, 2016 at 9:22 AM, Rick Cook wrote: > ** > > The string functions should be able to do that. Look in the appendix of > your AR System documents. > > Rick > On Apr 22, 2016 7:21 AM, "Satya Miller" 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_ > > _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"
Re: Proper Case
The string functions should be able to do that. Look in the appendix of your AR System documents. Rick On Apr 22, 2016 7:21 AM, "Satya Miller" 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"
Proper Case
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. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"