I have this table
and need to take the numbers after hyphen in CAD_DESIGN_ROOMID field and put it before the last three letters in ROOMCODE field with another hyphen. I need the result to look like this :
any idea how I can do that in python. considering I am working in an SDE GDB and can't add more fields.