How can we write a rule which compares the string in PIM?

Summary:

Hello,

There is a requirement to write a rule where once an item ABC is created it automatically gets a sequence through Manage Item Rule which starts with 000. So the output is ABC000. If another ABC item is created it will be ABC001, and it will increase as ABC02, ABC03 etc.

If an item CDE is created it is also created as CDE00 and as new items are created it will be CDE001, CDE002 etc.

These letters ABC, CDE etc. are coming from Manage Item Attribute/Groups and rules.

In summary, the requirement is that the items are created as below: