Python code

Question

Hi Pros;

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 :

ART-S-01-00-1050-1-(OFS)

ART-S-01-00-1050-2-(OFS)

ART-S-01-00-1050-3-(OFS)

.

ART-S-01-00-1050-19-(OFS)

any idea how I can do that in python. considering I am working in an SDE GDB and can't add more fields.

Thanks

eyadghatasheh · Answer

Thanks a million Dan;

I think we have to remove the + "-" after the first part ( a.split("(")[0] ) as it gives double hyphen in the result like ART-S-01-00-1050--1-(OFS)

but anyway, this was helpful, many thanks again

DanPatterson_Retired · Answer

c is a ... it would be best if it went into a new field, but if you have to overwrite 'a' then you would do the field calculation on it.  A practice I am not recommending (except on a backup copy of the table)

eyadghatasheh · Answer

Thanks Dan

I assume the C is a new field; right? if yes this will not work as I can't add field as I don't have admin privileges on this GDB.