How do I remove the first 15 characters in a field?

HalilSiddique — Mon, 25 Jul 2011 15:18:21 GMT

Hi all,

Can someone advise me on how to remove the first 15 characters in a field

I have the following code

# Import system modules
import sys, string, os, arcgisscripting
# Create the Geoprocessor object
gp = arcgisscripting.create(9.3)
# Overwrite data
gp.OverwriteOutput = 1
# Allow fields not to be appended
gp.qualifiedFieldNames = "false"
# Local variables...
inputView = "Database Connections\\UNIFORM BIZTALK.sde\\UNI72LIVE.LLPG"
inputPoint = "Database Connections\\UNISDE on singapore 5155.sde\\UNISDELIVE.UFRM_BLPU_POINT"
featurePoint = "UFRM_BLPU_POINT_Layer"
llpgView = "GIS_LLPG_SOURCE_View"
SDELayer = "Database Connections\\CORPDATA.sde\\ESRIGIS.CORPDATA.BLPU_Property_Points_NEW"
try:
    # Process: Make Feature Layer...
    gp.MakeFeatureLayer_management(inputPoint, featurePoint, "", "", "KEYVAL KEYVAL VISIBLE NONE;UPRN UPRN VISIBLE NONE;CREATEDBY CREATEDBY VISIBLE NONE;MODIFIEDBY MODIFIEDBY VISIBLE NONE;DATE_CREATED DATE_CREATED VISIBLE NONE;DATE_MODIFIED DATE_MODIFIED VISIBLE NONE;STATUS STATUS VISIBLE NONE;TRANSACTION_TYPE TRANSACTION_TYPE VISIBLE NONE;SYMBOL SYMBOL VISIBLE NONE;X X VISIBLE NONE;Y Y VISIBLE NONE;LOGICAL_STATUS LOGICAL_STATUS VISIBLE NONE;ACCURACY ACCURACY VISIBLE NONE;ADDRESS ADDRESS VISIBLE NONE")
    print "1 - Make BLPU points into a View - Complete"
    
    # Process: Make Table View...
    gp.MakeTableView_management(inputView, llpgView, "", "", "S_NAME S_NAME VISIBLE NONE;LOCALITY_NAME LOCALITY_NAME VISIBLE NONE;TOWN_NAME TOWN_NAME VISIBLE NONE;COUNTY_NAME COUNTY_NAME VISIBLE NONE;START_NO START_NO VISIBLE NONE;START_SFX START_SFX VISIBLE NONE;END_NO END_NO VISIBLE NONE;END_SFX END_SFX VISIBLE NONE;DESCRPT DESCRPT VISIBLE NONE;SO_START_NO SO_START_NO VISIBLE NONE;SO_START_SFX SO_START_SFX VISIBLE NONE;SO_END_NO SO_END_NO VISIBLE NONE;SO_END_SFX SO_END_SFX VISIBLE NONE;SO_DESCRPT SO_DESCRPT VISIBLE NONE;POSTCODE POSTCODE VISIBLE NONE;POST_TOWN POST_TOWN VISIBLE NONE;ORGANISATION ORGANISATION VISIBLE NONE;UPDATED_D UPDATED_D VISIBLE NONE;BLPU_CLASS BLPU_CLASS VISIBLE NONE;BLPU_CLASS_DESC BLPU_CLASS_DESC VISIBLE NONE;LOGICAL_STATUS LOGICAL_STATUS VISIBLE NONE;UPRN UPRN VISIBLE NONE")
    print "2 - Make LLPG into a View - Complete"
    
    # Process: Add Join...
    gp.AddJoin_management(featurePoint, "UPRN", llpgView, "UPRN", "KEEP_COMMON")
    print "3 - Join Points to table - Complete"
    
    # Process: Delete Features...
    gp.DeleteFeatures_management(SDELayer)
    print "4 - Delete the features in the SDE later - Complete"
 
    # Process: Append...
    gp.Append_management(featurePoint, SDELayer, "TEST", "", "")
    print "5 - Append the updated BLPU to SDE layer - Complete"
    
    print "Done"
except:
    print "Error has occured"
    print gp.getmessages()

When the Add Join occurs, it calls the field UNI72LIVE_LLPG_BLPU_CLASS_DESC I just want the field to be called BLPU_CLASS_DESC, and i want this to occur for all the fields that have "UNI72LIVE_LLPG_" as part of the field name.

Anyone got any idea on how to do this?

Cheers

halil

Re: How do I remove the first 15 characters in a field?

BruceNielsen — Mon, 25 Jul 2011 15:56:06 GMT

In python, this is usually achieved through slicing. To keep all but the first X characters of a string, append returns '67890'.

Slicing is covered in the section on strings in the tutorial part of the Python documentation.

topic How do I remove the first 15 characters in a field? in Python Questions

How do I remove the first 15 characters in a field?

Re: How do I remove the first 15 characters in a field?