Incrementing an attribute value

Incrementing an attribute value

  

I have an attribute (data type - text) of an entity and I want to increment its value starting with AB0001 and then AB0002, AB0003 and so on.

How to do it?

What do you think how it should be done?


Hi Ananth,

If the attribute always start with two letters, consider the following logic:

'Cut' the first two characters, convert the rest to integer, add 1, convert back to text, reconstruct the text adding the original two letters and the zeros needed (hint: check the incremented text's length to know how many you'll need).