View previous topic :: View next topic
|
Author |
Message |
pkmurali Warnings : 1 Active User
Joined: 15 Dec 2005 Posts: 271
|
|
|
|
Hi,
I like to know is there any option to elliminate duplicates from a file using FOCUS. Please let me know.
Regards,
murali. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
When you read a record that has the same value of the previous record, skip that record? |
|
Back to top |
|
|
pkmurali Warnings : 1 Active User
Joined: 15 Dec 2005 Posts: 271
|
|
|
|
Dick,
Thanks for your reply.
My file has following structure
accountno acctname address-1 address-2
10000 xxxxx 01east crtt
10002 yyyyy 55west drtt
10000 xxxxx 01east crtt
TABLE FILE DAILY
PRINT ACCTNAME
BY ACCOUNTNO
END
Is there any builtin function like NODUPS in ICETOOL,SUMFIELDS=NONE in SORT utility etc. in FOCUS instead of comparing two values and elliminating? |
|
Back to top |
|
|
pkmurali Warnings : 1 Active User
Joined: 15 Dec 2005 Posts: 271
|
|
Back to top |
|
|
|