two files matching with icetool
Posted: Wed Oct 07, 2009 7:05 pm
Hello all, final accusing my English is not so good!
I have the following problem
IN1 (with only old key in colums 1-4)
AAAA
AAAA
BBBB
CCCC
IN2 (with two keys, old in colums 1-4 and new in colums 6-9)
AAAA 1111
CCCC 3333
OUT
1111 AAAA
1111 AAAA
BBBB BBBB
CCCC 3333
OUT all from IN1
- new-key (IN2) old-key (IN1) - the old key is present in IN1 and IN2 or
- old-key (IN1) old-key (IN1) - the old key is only in IN1
Please let me know if we can write an ICETOOL for this
Thanks in advance
Joachim
I have the following problem
IN1 (with only old key in colums 1-4)
AAAA
AAAA
BBBB
CCCC
IN2 (with two keys, old in colums 1-4 and new in colums 6-9)
AAAA 1111
CCCC 3333
OUT
1111 AAAA
1111 AAAA
BBBB BBBB
CCCC 3333
OUT all from IN1
- new-key (IN2) old-key (IN1) - the old key is present in IN1 and IN2 or
- old-key (IN1) old-key (IN1) - the old key is only in IN1
Please let me know if we can write an ICETOOL for this
Thanks in advance
Joachim