Parse info

[pamgdevlin]

Say I have a text field with 5 words, each separated by a space.....for example:

Mary had a little lamb

Using a query, what would be the best way to pull out the third "word" 'a'??

Any suggestions would be appreciated.

Thanks

 

[PHV]

Create your own public function.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[jebry]

Hi!

In a query you would do it like this:

Mid(YourField, InStr(InStr(YourField," ") + 1, YourField, " "), InStr(InStr(InStr(YourField," ") + 1, YourField, " ") + 1, YourField, " ") - InStr(InStr(YourField," ") + 1, YourField, " "))



Jeff Bridgham
Purdue University
Graduate School
Data Analyst

 

[jebry]

Hi!

A small error:

ThirdWord: Mid([YourField],InStr(InStr([YourField]," ")+1,[YourField]," ")+1,InStr(InStr(InStr([YourField]," ")+1,[YourField]," ")+1,[YourField]," ")-InStr(InStr([YourField]," ")+1,[YourField]," ")-1)

hth


Jeff Bridgham
Purdue University
Graduate School
Data Analyst

 

[pamgdevlin]

Thanks so much for your help!!!