Results 1 to 3 of 3

Thread: Get Left Word

  1. #1
    Join Date
    Jul 2002
    Posts
    35

    Unanswered: Get Left Word

    I have a text field and I only need the left word. What would I write in a calculated field to get me that word.

    I figure something like Left([ad line], len ????

    Any suggestions, Thanks.

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Left([ad line], instr([ad line]," ")-1 )

    the length for Left() is one less than the position of the first space


    rudy

  3. #3
    Join Date
    Jul 2002
    Posts
    35
    You are great R937!!!

    Thanks for you help.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •