Results 1 to 2 of 2

Thread: Left Substrin

  1. #1
    Join Date
    Oct 2002
    Location
    Hartford, CT
    Posts
    106

    Unanswered: Left Substrin

    Hi,

    I have a field that has the first, last and Middle Initial fields combined together. They are somewhat space delimited. I would like to separate only the Middle Initial in a separate field using the IIF function.

    The data is like this

    Smith John S
    D Marco Tom L
    Van Rros Mike B

    My theory was to evaluate the Last-1 if = space, then Middle_Initial = Last.

    Is that doable?

    Please help
    Thanks a lot
    Mo

  2. #2
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    instr is almost the same. izy

Posting Permissions

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