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 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
> To: arslist
> 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"