Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2003
    Posts
    10

    Unanswered: Moving text to the left of a space

    Does anyone know of a function which I can use in a query which will enable me to take some the text in a field and remove (or move) whatever is before the first space in the text? eg "58 longbig close". move the 58 to another field?


    many thanks

  2. #2
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1

    Lightbulb Re: Moving text to the left of a space

    Originally posted by Vingss
    Does anyone know of a function which I can use in a query which will enable me to take some the text in a field and remove (or move) whatever is before the first space in the text? eg "58 longbig close". move the 58 to another field?


    many thanks
    use the INSTR Function to dertrmine where the first space is. Then the SUBSTR Function to get the string form the first char. to the first space.

  3. #3
    Join Date
    Nov 2003
    Location
    Warren, PA
    Posts
    52
    See the attached file for additional help
    Attached Files Attached Files

  4. #4
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    Originally posted by bhummel
    See the attached file for additional help
    Sorry I can't open it, can you send it in Access97 format....

  5. #5
    Join Date
    Nov 2003
    Posts
    10
    Thanks very much I'll take a look

Posting Permissions

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