ITSM 7.6.04 - removing a value

2012-01-04 Thread Sanford, Claire
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.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"


Re: ITSM 7.6.04 - removing a value

2012-01-04 Thread Roger Justice
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"


Re: ITSM 7.6.04 - removing a value

2012-01-04 Thread Kevin Begosh
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"