I have file (fb,80) where could be combination of AA or BB or CC or DD in any position ( only one combination per record) . Is it possible to change 3 position before combination to 111 if it is 000 there.
Sorry, I read my post and understood, that you will probably suggest me to use FINDREP function .... but real case more complicated, then I define it initially ...in general - I need to work /change 3 position before combination of AA,BB,CC,DD
Joined: 10 May 2007 Posts: 2255 Location: Hampshire, UK
Are you saying that there must be 4 records present (1 x AA, 1 x BB, 1 x CC and 1 x DD) before you can change 000AA to 111AA in that group of four?
If so, will there only be four records in the group to be changed?
sorry, it was typo with certain ...
I am saying that if combination of AA is in the record, then not other combinations as BB, CC etc in this record...
I cannot use FINDREP 000AA to 111AA because it is more complicated - it is not just change 000 to 111 ... it is in my request, but I need idea how to change 3 positions before combination .... it is not just 000 to 111 ...maybe better to explain .... I need to change 3 position before AA to 111 if this 3 positions NOT = 000 ... could be 123 or 321 or 1g1 ... so I cannot use FINDREP