String manipulation

[Patrick]

HI ALL!!

I need a code example of how to get the first word in a
sentence:
Ex.: "Allseating Corporation Inc."
3 words..
Need to return: "Allseating"

How would I do that programmatically.

Thanks for any help,
PAtrick

 

[Ken Snell]

FirstWord = Left("Allseating Corporation Inc.", InStr("Allseating
Corporation Inc.", " ") - 1)

You can use a variable in place of the text string.

 

[Patrick]

Thanks a million, just what I needed!!

-----Original Message-----
FirstWord = Left("Allseating Corporation Inc.", InStr ("Allseating
Corporation Inc.", " ") - 1)

You can use a variable in place of the text string.

--
Ken Snell
<MS ACCESS MVP>




.

 

[Albert D. Kallal]

Try:

split("Allseating corporation Inc."," ")(0)

 

[Albert D. Kallal]

sorry, Ken, I did not mean to append this to your post....but Patrick's...

 

[Ken Snell]

no problem!

 

[lin lin]

Try:

split("Allseating corporation Inc."," ")(0)


--
Albert D. Kallal (MVP)
Edmonton, Alberta Canada
(e-mail address removed)
http://www.attcanada.net/~kallal.msn