View previous topic :: View next topic |
Author |
Message |
ta0010274 Beginner
Joined: 08 Jan 2008 Posts: 8 Topics: 3
|
Posted: Sat May 09, 2009 6:48 am Post subject: DFSORT/ICETOOL |
|
|
Hi All,
I have a requirement, please help me. I have two files of each 10 byte fixed length records and i need to have a final file with the below required output. i.e. the final file should have the dat with first 10 bytes of file1 and first byte of second file.
File1:
AAAAAAAAAA
BBBBBBBBBB
CCCCCCCCC
DDDDDDDDD
File2:
1XXXXXXXXX
2YYYYYYYYYY
3ZZZZZZZZZ
4KKKKKKKKK
Final File(with 11 record length):
AAAAAAAAAA1
BBBBBBBBBB2
CCCCCCCCC3
DDDDDDDDD4
Thanks,
Thiru |
|
Back to top |
|
|
kolusu Site Admin
Joined: 26 Nov 2002 Posts: 12376 Topics: 75 Location: San Jose
|
Posted: Sun May 10, 2009 4:54 am Post subject: |
|
|
ta0010274,
I don't see any common matching keys in either files. How does you related as to which value needs to be appended to file1 from file1?
Is it like the first record of file1 should take value the first record of file2 , the second record record of file1 should take value the second record of file2 and so on ?
If that is the case do we always have equal number of records in both files?
On second thoughts do you just want to append a 1 digit sequence number in pos 11 for file1? _________________ Kolusu
www.linkedin.com/in/kolusu |
|
Back to top |
|
|
|
|