<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:12pt"><div><span>Scott,</span></div><div><span></span> </div><div><span>This should be rather simple to do. I have processes that run weekly to some files to do the same thing since fp does not have a pack feature.</span></div><div><span></span> </div><div><span>Copy to database [db1] in question to a new db [db2] using fpcopy. You do not want to copy data and don't need the reports forms, etc.</span></div><div><span>Create a process to (1) see if the acount aleady exists in the new db </span></div><div><span>(2a) if not copy</span> the full data to the new db.<br>(2b) if it exists check the date to see if the record is newer then copy & replace data or if not skip it and do not copy.</div><div>(3) when done you should have a 'clean' database in db2.</div><div>(4) you can then erase db1 and copy db2
back or rename it, your choice.</div><div> </div><div>IMPORTANT: Always back a copy / backup before any mass changing or deleting.</div><div> </div><div>Hope this helps,</div><div>Rick Hane</div><div>Controller</div><div>Deluxe Stitcher Company Inc</div><div> </div> <div style="font-family: times new roman, new york, times, serif; font-size: 12pt;"> <div style="font-family: times new roman, new york, times, serif; font-size: 12pt;"> <div dir="ltr"> <font size="2" face="Arial"> <div style="margin: 5px 0px; padding: 0px; border: 1px solid rgb(204, 204, 204); height: 0px; line-height: 0; font-size: 0px;" class="hr" contentEditable="false" readonly="true"></div> <b><span style="font-weight: bold;">From:</span></b> "scooter6@gmail.com" <scooter6@gmail.com><br> <b><span style="font-weight: bold;">To:</span></b> filepro-list@lists.celestial.com <br> <b><span style="font-weight: bold;">Sent:</span></b> Friday, March 22, 2013
11:56 AM<br> <b><span style="font-weight: bold;">Subject:</span></b> de-duping a file<br> </font> </div> <br>
I have a rather large file that may or maynot have multiple records based<br>on our 'Account Number' - there is also a 'date' field in this file<br><br>I'm trying to de-dup the file - that is, if there are more than 1 record<br>for 'each' account number, it should only keep the most current record.<br>If there is only one record for said 'Account Number' it should keep it and<br>do nothing - if there are multiple (2 or more) records for 'Account Number'<br>it should keep the most current dated one<br><br>i.e.<br>Account Number is 1234-5678<br>There are 3 records in file with '1234-5678' as 'Account Number'<br>One dated 01/12/13<br>One dated 02/01/13<br>One dated 03/18/13<br><br>I want it to delete both records dated 01/12/13 & 02/01/13 but keep the one<br>from 03/18/13<br><br>Not quite sure how to go about doing this quickly....<br><br>thanks<br><br>Scott<br>-------------- next part --------------<br>An HTML attachment was
scrubbed...<br>URL: http://mailman.celestial.com/pipermail/filepro-list/attachments/20130322/04ebe527/attachment.html <br>_______________________________________________<br>Filepro-list mailing list<br><a href="mailto:Filepro-list@lists.celestial.com" ymailto="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a><br>Subscribe/Unsubscribe/Subscription Changes<br>http://mailman.celestial.com/mailman/listinfo/filepro-list<br><br><br> </div> </div> </div></body></html>