increment the identifcation number

Question

Hi,

I have incoming data with an alphanumeric id as an identification number, like say abc01, abc02. Going forward, the data will be received without the identification number. So, I need to generate the unique alphanumeric id's by looking at the max alphanumeric id in the previous extract and then incrementing from there.

For ex: In the last data extract I received, max value of the alphanumeric id is abc42. For the next batch that I will receive, I need to start generating the alphanumeric id from abc43.

Thanks,

AncientPandaman · Accepted Answer

get the last id, then split into the prefix part and the running number part. (use regex tool)
add back the running number back to table, and add it with recordID.

then add back the prefix part.