As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you have any questions or need access: Contact email@example.com
I was just wondering if there is a function that can check characters for duplicates. For example: I have a file with 150 records of ssn's, first name, lastname, address, dog, cat, anut, uncle, salary... and so forth. tons of data.
What I want to do is run through the file and make sure there is only 1 ssn (other wise we would have 2 records exatly the same).
Is there a looping function that can go through each row of a file and check that? Can this be done in a define without the use of a hold file?
Why not count the SSN's by SSN and print a report where the count is greater than one?Here's an example using the CAR file. I am using the SEATS field. First run the report with the WHERE clause commented, then run it uncommented to see the difference.
TABLE FILE CAR
CAR BY SEATS
*WHERE TOTAL CNT.SEATS GT 5
This message has been edited. Last edited by: <Mabel>,
Those suggestions are very helpful. I was trying to think of a way to do it in a define, but I am now actually using a whole report to do a count, so I think what was suggested will work. Thanks so much!!