Results 1 to 6 of 6

Thread: Parsing

  1. #1
    New Lounger
    Join Date
    Aug 2002
    Location
    Orange Park, Florida, United Arab Emirates
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Parsing

    Have two tables. Table1 contains names, slit into two fields, and addresses of customers utilized for followup advertising. Table2 results from output of "point of sale" program which lists names as one field. What is the best method to parse the names from Table2 and then append to Table1?

  2. #2
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    The Netherlands
    Posts
    216
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Parsing

    Open a recordset on table2.
    Check for each record whether it exists in table1 (there are several functions you can use for this)
    If not exists: append a new record to table1.

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Parsing

    That depends on which version of Access you're using. Why don't you post that, along with anything you've tried, so you can get the best answer for your particular situation.
    Charlotte

  4. #4
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Parsing

    In addition to what Charlotte asked, we also need to know what delimits the two halves of the name in table 2? Can there be more than one of the delimiter (a space for example), and how do you know which to use?
    Legare Coleman

  5. #5
    New Lounger
    Join Date
    Aug 2002
    Location
    Orange Park, Florida, United Arab Emirates
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Parsing

    Am using Access 2000. As of yet, I haven't tried anything since I'm not sure which is the best way to proceed. As a relatively new user, I'm still feeling my way. The output from the "point of sale" program places the customer's name into a single field with the first and last seperated by a space so I realize that could be used to parse that field. What I'm uncertain about is what procedure to employ to accomplish this. A query seems to be the answer but nothing I've read indicates how to accomplish this.

  6. #6
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Parsing

    A query like the following should work:
    Attached Images Attached Images
    Legare Coleman

Posting Permissions

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