I have two files. first file is of record length 582 and second file is of length 80.
i have few fields in first file and a field named key which is of 8 length.
in the second file i have only two fields that is new key and old key both are of 8 length.
now i have to compare this two files find if the old key is present in the first file if present then replace the old key with new key which is present in file 2. if there is no match then it should have the same old key and nothing should be changed
i worked with the below code
JOIN UNPAIRED,F1 ONLY
but if they cant find old key in the file it is getting filled with blank, i want the old key as old key if there is no match.. can somebody please help? thanks in advance
file 1----------key starts at position 17 and of length 8
file 2 ---------1-8(new key) 9-16(old key)