I have a dataset with 3000 polygons represting streets. Each street is divided into subparts and need a unique code to be assgined. The first part refers to the streetname and is the same for each subpart, 2nd part is a unique counter.
Image below shows my current (top) and wanted situation (bottom part).
Any support is appreciated!
![](https://uploads-us-west-2.insided.com/safesoftware-en/attachment/23600fd6-f4c6-4f7a-a2f9-5d0f7445d9b8.png)