I need to replace the 3rd and 4th digits of street addresses with 'X' and strip any apt info from the end.
Fer example "1756 Cedar St 4D' should become 17XX Cedar St
The closest I've come is:
!USER_Address_Line_1!.replace('0123456789','X')[2:3]
!USER_Address_Line_1![2:3].replace('0123456789','X')
but those just seems to turn the entire address into a single digit number
To remove the apartments, I got as far as removing numbers at the end using
!USER_Address_Line_1!.rstrip('0123456789')
but that still leaves lettered apartment units
I'm using ArcGIS Pro 2.8 and Python 3