This is what I did I had a field called New Full Name and I populate the name, John Smith from the field Old Field Name that had John G Smith.
(SUBSTRC($OldFullName$, 0, STRSTRC($OldFullName$, " ") - 1) + " ") + RIGHTC($OldFullName$, STRSTRC($OldFullName$, " ") + 1) This gets the string from the first part up to the first space, so first name then adds a space then gets the last night via right command up to the other space. On 1/4/12, Roger Justice <rjust2...@aol.com> wrote: > Review STR STR command. Determine location of the first space and the second > space and use these values to do a substr. > > > > -----Original Message----- > From: Sanford, Claire <claire.sanf...@memorialhermann.org> > To: arslist <arslist@ARSLIST.ORG> > Sent: Wed, Jan 4, 2012 12:57 pm > Subject: ITSM 7.6.04 - removing a value > > > ** > I need an easy no brainer fix. I think my brain is shot. I can’t think > straight and my logic skills are shot at the moment. > > I have a field that was populated with First MI Last > > I need to get rid of the MI. > > I was able to do it with one field on the form, but I had a FN and a LN > field to reference. With this one field, I don’t have that. > > I have > > Bob H Smith > > I want > > Bob Smith > > There is no punctuation in the field. > _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" > -- Kevin Begosh _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
