Prev: hey
Next: Managing ourt d
From: Joe M. on 9 Feb 2010 09:10
Hi. I will try that. In the meantime, I found another solution that works:

Short_Desc2: Right([Field1],Len([Field1])-InStr([Field1]," "))

"stumac" wrote:

> Hi Joe, try:
>
> Short_Desc: Mid([field1],InStr(1,[field1]," ")+1)
>
> Hth
>
> Stu
>
> "Joe M." wrote:
>
> > I have a query that needs to return the part of the original string after the
> > first blank. In other words I want to cut off the first word as shown below
> > in Short_desc. Originally I was using the following formula when I thought
> > the first word was "The". In this formula, if "The" is not present then the
> > result is the original string.
> >
> > Short_Desc: IIf(Left([Field1],3)="The",Mid([Field1],5,35),[Field1])
> >
> > Here's what I need. Note that if there is only one word then the entire
> > string is returned (record 4).
> >
> > Field1 Short_Desc (Desired result)
> > Record 1: "The Apples" "Apples"
> > Record 2: "Another Time" "Time"
> > Record 3: "What problem" "Problem"
> > Record 4: "Alltogether" "Alltogther"
> >
> > Can someone help?
> > Thanks,
> > Joe M.
 | 
Pages: 1
Prev: hey
Next: Managing ourt d