Globally update value from -99 to Blank

FME doesn't have a global value replacer. But perhaps you can use the StringReplacer. You would need one for each feature class though.

Hi Steve,

 

 

It would be possible to make something with an AttributeExploder and a looping custom transformer, but a PythonCaller is probably the fastest and easiest solution, as SigTill also suggests. Here is an example:

 

 

import fmeobjects   def global_string_replacer(feature):     attributes = feature.getAllAttributeNames()     for attrib in attributes:         value = feature.getAttribute(attrib)         if str(value).strip() == "-99":      # Search             feature.setAttribute(attrib, "") # Replace

 

It is easy to convert this into a custom transformer where the search and replace strings are given as parameters, if necessary.

 

 

To read all the features classes in a File Geodatabase, you could use the reader "Schema (Any Format)" and then pass the list of feature class names to a FeatureReader.

 

 

David

 

 

Good to hear it worked, Steve.

 

 

The PythonCaller is an incredibly powerful transformer once you "get" it, I can heartily recommend spending some time to understand its capabilities!

 

 

Here are some starting points:

• Python and FME http://fmepedia.safe.com/articles/How_To/Python-and-FME-Basics
• Free Python e-book: http://www.diveintopython.net/toc/index.html

Feel free to ask here if you have questions on your path to Python mastery with FME!

 

 

David