|
View previous topic :: View next topic
|
| Author |
Message |
Vinod1111
New User
Joined: 17 Sep 2022
Posts: 4
Location: India
|
|
|
|
Ex:
1
A
B
2
C
D
1
A
B
2
C
D
3
A
B
The first 6 are duplicates and needs to be deleted, can someone give sort card for the above scenario? |
|
| Back to top |
|
 |
dneufarth
Active User
Joined: 27 Apr 2005
Posts: 420
Location: Inside the SPEW (Southwest Ohio, USA)
|
|
|
|
| Have you tried searching the DFsort forum? I am sure a solution to your need will be found. |
|
| Back to top |
|
|
sergeyken
Senior Member
Joined: 29 Apr 2008
Posts: 2023
Location: USA
|
|
|
|
Start from here:
DFSORT Manual Guide
Nobody is going to do your job for you. You are paid for this, but you do not plan even to start working. |
|
| Back to top |
|
|
Vinod1111
New User
Joined: 17 Sep 2022
Posts: 4
Location: India
|
|
|
|
Thanks, will go through the guide. Appreciate taking time for this.
Any leads will definitely help. |
|
| Back to top |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010
Posts: 3053
Location: NYC,USA
|
|
| Back to top |
|
|
Joerg.Findeisen
Senior Member
Joined: 15 Aug 2015
Posts: 1255
Location: Bamberg, Germany
|
|
|
|
| It would be nice to have a real sample of the data. Are all groups of same length, how to identify a group (start/end) and so on. |
|
| Back to top |
|
|
Vinod1111
New User
Joined: 17 Sep 2022
Posts: 4
Location: India
|
|
|
|
Sample data:
HEADER
AAAA
BBBB
CCCC
HEADER
AAAA
BBBB
CCCC
CCCC
HEADER
AAAA
BBBB
CCCC
CCCC
DDDD
EEEE
Expected output:
HEADER
AAAA
BBBB
CCCC
CCCC
DDDD
EEEE |
|
| Back to top |
|
|
sergeyken
Senior Member
Joined: 29 Apr 2008
Posts: 2023
Location: USA
|
|
|
|
1) Any attempt to try any sample related to your task? - Before asking others to help you.
Nobody is going to do your job for you in full. You are paid for this, but you do not plan even to start working.
2) Please, first of all: learn how to use the Code button when posting at the forum!
| Code: |
This is my code
This is more code
. . . . . .
Here my code ends |
3) Hint: try to read something about
In some cases (likely not your case) the following might be needed
| Code: |
| OUTFIL ...SECTIONS=... |
or
| Code: |
| OUTREC ...WHEN=GROUP... |
Then present here: what you were able to do by yourself? |
|
| Back to top |
|
|
Garry Carroll
Senior Member
Joined: 08 May 2006
Posts: 1193
Location: Dublin, Ireland
|
|
|
|
| Quote: |
Expected output:
HEADER
AAAA
BBBB
CCCC
CCCC
DDDD
EEEE |
You need to define your requirements accurately. You say you want to remove duplicates yet your expected output contains duplicates (CCCC). What are your criteria for sometimes retaining duplicates?
Garry. |
|
| Back to top |
|
|
|
|
