Hi I am very new to ArcGis and Python
I recently had a data change that broke SpatialJoin line in a script we run to compile ArcGIS data for a database import.
The data in the ORD_NUM field can now get to be longer than 25 characters long.
parcel, ConditionalUse, parcel_conuse, "JOIN_ONE_TO_ONE", "KEEP_ALL", "PARCEL_ID \"PARCEL_ID\" true true false 50 Text 0 0 ,First,#,"
+vars.path_to_database+"/Parcel.mdb/Parcel/PARCEL_Limits,PARCEL_ID,-1,-1;ORD_NUM \"ORD_NUM\" true true false 25 Text 0 0 ,Join,\",\","
+vars.path_to_database+"/CommDev.mdb/CommDev/ConditionalUse,ORD_NUM,-1,-1", "INTERSECT", "-1 Feet", "")
My original answer to this issue was to change the field length here to 50. However that broke the database process and unfortunately I can not change that process right now.
So instead I would like to change this line so it truncates the data to 25 characters for the ORD_NUM field instead of failing like it does now.
This is a temporary fix until the database process can be adjust to handle the longer data. I tried setting the -1, -1 to 0, 25 but that didn't fix the issue. It still errored.
Is there anything else I can do to this line to force it to truncate the data at 25 characters instead of failing?