HP3000-L Archives

August 1997, Week 1

HP3000-L@RAVEN.UTC.EDU
Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
Re: Duplicate Records
From:
ROGER SMITH <[log in to unmask]>
Reply To:
ROGER SMITH <[log in to unmask]>
Date:
Tue, 5 Aug 1997 09:20:01 -0500
Content-Type:
text/plain
Parts/Attachments:
text/plain (31 lines) 
Arnone,
You have already received many suggestions.  This is simpler than most
suggested.

access *subfile
sort on ssn
set subfile name newsub at ssn
report summary all
go

This will write only one record per ssn.  You can rename the two files
if you need the last file.
>----------
>From:  CPL ARNONE,PROGRAMMER,DSN 288-2356[SMTP:[log in to unmask]]
>Sent:  Tuesday, August 05, 1997 6:32 AM
>To:    [log in to unmask]
>Subject:       Duplicate Records
>
>        Good Morning,
>
>                I have a subfile in which there  are duplicate records in the
>file (file contains : ssn,lastname). I need to weed out the duplicates.
>Unfortunately everything I seem to try seems to not want to work. Any help
>would be appreciated.
>
>
>Anthony P Arnone
>E-mail: [log in to unmask]
>Marine Corps Institute
>

ATOM RSS1 RSS2