topic Re: Adding a field name and Parsing the filename in model builder in ModelBuilder Questions

Adding a field name and Parsing the filename in model builder

VincentOgodo — Mon, 14 May 2018 22:12:49 GMT

I have created a new field name to hold the filename of each table am iterating. I have used the parse path to collect the filename but and preconditioned the the parsing so that the field can be added first before the filename is populated in the new created field. When I run the model I an error that workspace not set for geoprocessor. Any help please?

Vincent

Re: Adding a field name and Parsing the filename in model builder

JoeBorgione — Tue, 15 May 2018 02:06:49 GMT

Check this out : 000638: Workspace not set for GeoProcessor.—Help | ArcGIS Desktop

And this: https://community.esri.com/thread/48342

I can't quite get through your models logic, but make sure you are accessing a fgdb and not a feature class. A workspace 'holds' the feature or table, so a workspace can be a directory (folder) that has a shapefile or dbf table.

Re: Adding a field name and Parsing the filename in model builder

curtvprice — Tue, 15 May 2018 04:21:35 GMT

You really don't need the Parse Path step -- Name is already parsed, Name is the name of the table without any file extension. You can simply use Name in your Calculate Field expression -- that is: "%Name%".

Re: Adding a field name and Parsing the filename in model builder

VincentOgodo — Tue, 15 May 2018 08:47:04 GMT

This did not work. It created the field name but failed to populate the names. It resulted in empty records.

Re: Adding a field name and Parsing the filename in model builder

VincentOgodo — Tue, 15 May 2018 08:50:47 GMT

I managed to overcome the problem and it works fine. The new problem I have now is how to select part(s) of the file names to be populated in to the new created field. As it is the whole file name is written but I just would like parts of the filename.

Re: Adding a field name and Parsing the filename in model builder

DanPatterson_Retired — Sun, 12 Dec 2021 10:06:00 GMT

What is an example of the filename that is being returned?

If it is a string, then there is not tool in arctoolbox to parse text, this can be done via a script or even a field calculator expression parsing the part you want. For example to get the featureclass name from a full path in python you would use

fn = "C:/folder/file.gdb/featureclass"

fn.split("/")[-1]

'featureclass'‍‍‍‍‍

where fn would be your filename

Re: Adding a field name and Parsing the filename in model builder

VincentOgodo — Tue, 15 May 2018 09:04:48 GMT

Thanks Dan,

Am actually dealing with Tables. The fieldname is a string e.g. et_2003-2004c12 where the last two digits are indicates month of december. 2003-2004 represents the years which I also want to extract out into a separate field. I am a dummy with scripting in python let alone programming strings.

Re: Adding a field name and Parsing the filename in model builder

DanPatterson_Retired — Sun, 12 Dec 2021 10:06:03 GMT

For your future reference... it is python 'slicing'

d = "et_2003-2004c12"
y = d[3:12]
m = d[-2:]
d, y, m('et_2003-2004c12', '2003-2004', '12')‍‍‍‍