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 <[email protected]> To: arslist <[email protected]> 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"
