topic Re: Python code in Python Questions

Python code

eyadghatasheh — Wed, 04 Dec 2019 09:40:20 GMT

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

Re: Python code

DanPatterson_Retired — Sat, 11 Dec 2021 13:30:05 GMT

with a code block and you replacing 'a' and 'b' with their appropriate fieldnames in double ! marks

a = "ART-S-01-00-1050(OFS)"
b = "1050A-1"
c = a.split("(")[0] + "-" + b.split("-")[-1] + "-(" + a.split("(")[-1]

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

# ---- a = !a_field!  b = !b_field!‍‍‍‍‍‍‍‍

But you had better have an undo or check your results before committing the results.... otherwise, its on you

Re: Python code

eyadghatasheh — Wed, 04 Dec 2019 11:24:42 GMT

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.

Re: Python code

DanPatterson_Retired — Wed, 04 Dec 2019 11:31:21 GMT

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)

Re: Python code

eyadghatasheh — Wed, 04 Dec 2019 11:49:38 GMT

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