Results 1 to 6 of 6
  1. #1
    Join Date
    May 2003
    Posts
    5

    Unanswered: List Purging Application

    Need an Access application to purge a .txt list like this one:

    "9724903716","Abello A","5060 Addison Cir","Addison","TX","75001"
    "9724077328","Acosta Marleny","16951 Addison Rd","Addison","TX","75001"
    "9728186859","Alaniz Manuel","16951 Addison Rd","Addison","TX","75001"
    "9724886763","Aleman Ignacio R","4010 Brookhaven Club Dr","Addison","TX","75001"
    "9726207323","Ali Batool","3925 Brookhaven Club Dr","Addison","TX","75001"
    "9724068054","Almanza Joaquin","4015 Brookhaven Club Dr","Addison","TX","75001"


    using another .txt list like this :

    "2095437608"
    "2095438023"
    "2095438447"
    "2095438784"
    "2095439839"
    "2095440421"
    "2095440713"
    "2095441053"

    and outputting a "clean.txt" and the "differential.txt"

    Please advise.

    Walter Conti

  2. #2
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    maybe a little more detail on what you are trying to do will help... izy

  3. #3
    Join Date
    May 2003
    Location
    Dallas
    Posts
    817
    Provided Answers: 5
    are you just trying to export data to a delimitted file?

  4. #4
    Join Date
    May 2003
    Posts
    5
    Hello AxProng, Izy

    Two inputs :
    - DirtyFile.txt, comma delimited, quoted
    - PhoneNumbers.txt

    Delete all records which contain the numbers in PhoneNumbers.txt

    Two outputs :
    - CleanFile.txt, identical to the input: comma delimited, quoted
    - DifferentialFile.txt containing the records that have been deleted.

    WalterC

  5. #5
    Join Date
    May 2003
    Location
    Dallas
    Posts
    817
    Provided Answers: 5
    I sent you a PM - read it

  6. #6
    Join Date
    May 2003
    Posts
    5
    Hello AxProng
    Nothing in my PM box.
    If necessary use walter@wconti.com

Posting Permissions

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