Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Jun 2003
    Location
    Utah, USA
    Posts
    405
    Thanks
    35
    Thanked 5 Times in 5 Posts

    Extract Word from a Field (2002 SP-2)

    Is there a way in a Report to extract a certain word from a field. Something like "right" and "left" which can extract a set of characters.

    I'd like to be able to form a report from a table with a field of complete names (first middle last), yet have the report show only the last or first name for certain entries.

  2. #2
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: Extract Word from a Field (2002 SP-2)

    Check the following posts and their threads which can accomplish part of what you want.

    <post#=146863>post 146863</post#>
    <post#=356368>post 356368</post#>
    <post#=356340>post 356340</post#>
    Regards,

    Gary
    (It's been a while!)

Posting Permissions

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