Quote:
Originally Posted by vukkusila
Hi experts,
I am new to scripting. I have a requirement as below.
File1:
A|123|NAME1
A|123|NAME2
B|123|NAME3
File2:
C|123|NAME4
C|123|NAME5
D|123|NAME6
1) I have 2 merge both the files.
2) need to do a sort ( key fields are first and second field)
3) remove all the instances of duplicate records from the merged file and write write all these duplicate instances into one file.
4) rest of the records which are unique in the original source files, needs to be written into another file
outfiles:
file3:
A|123|NAME1
A|123|NAME2
C|123|NAME4
C|123|NAME5
File4:
B|123|NAME3
D|123|NAME6
Please help me with the solution as I am in real urgent. Appreciate your help.
Thank you
|
If I am not wrong your each record in file1 and file2 seems to be unique data .I am pointing out the last character of your files.
SO if all data are unique all the records should go to File4 ..Is n't it?
Explain more clearly, so that you ll get a quick reply from this forum.
Beleive me here in this forum really brilliant and experts here to help you out at any time..
excluding me ..
Cheers
user_prady
