O
oli merge
Hi, i wonder if you can help,
i need to rename duplicate IDs to include an incrementing letter to make
them unique. the ids are alphanumeric, in the format: #A000#####. eg.
7F00013245. There is always a letter second digit, and always three zeros
after it. For reasons beyond my control, i need it to be the 3rd digit (1st
zero) that is replaced with a letter e.g. 7FA0013245 and the 2nd duplicate
would be renamed to 7FB0013245 etc etc.
also, just to make it more tricky, i have been asked not to include the
letter F when changing the 1st zero into a letter.
i cant quite work out how to go about this, any ideas?
i need to rename duplicate IDs to include an incrementing letter to make
them unique. the ids are alphanumeric, in the format: #A000#####. eg.
7F00013245. There is always a letter second digit, and always three zeros
after it. For reasons beyond my control, i need it to be the 3rd digit (1st
zero) that is replaced with a letter e.g. 7FA0013245 and the 2nd duplicate
would be renamed to 7FB0013245 etc etc.
also, just to make it more tricky, i have been asked not to include the
letter F when changing the 1st zero into a letter.
i cant quite work out how to go about this, any ideas?