Extracting the last word in a string

robboll · Joined: 07 Jan 2008 Posts: 1

What is the best method of extracting the last word in a string?
Example Table/Field1:

Field1
There once was a time
The old man sat
Two peas in a pod
One bird in the hand

function to extract the last word:

FunResult
time
sat
pod
hand

If it were the first word it would be: mid(Field1,1,instr(1,field1,"
"))

Thanks for any suggestions!

RBollinger

Archived from group: microsoft>public>vb>syntax

Ken Halter · Joined: 04 Oct 2007 Posts: 4150

"robboll" wrote in message @d21g2000prf.googlegroups.com...
> What is the best method of extracting the last word in a string?
> Example Table/Field1:
>
> Field1
> There once was a time
> The old man sat
> Two peas in a pod
> One bird in the hand
>
> function to extract the last word:
>
> FunResult
> time
> sat
> pod
> hand
>
> If it were the first word it would be: mid(Field1,1,instr(1,field1,"
> "))
>

Check out the InstrRev function... checks from the end of the string.

--
Ken Halter - MS-MVP-VB - Please keep all discussions in the groups..
In Loving Memory - http://www.vbsight.com/Remembrance.htm