Hello Forum,
I have an externally supplied dataset which includes a street name. Some of the street name entries are all in lower case (e.g.: royal road) where it should be Royal Road. However some entries are fine.
This is part of a larger regular data process, so I’d like to build in a process that fixes street names to proper upper/lower case (e.g.: royal road would become Royal Road).
Is this possible in FME Form?
Thanks,
Stuart
One way to do this is to use the StringCaseChanger set to Full Title Case.
Or use the function
@FullTitleCase(@Value(Street_name))
in an AttributeCreator.
You could use a python caller, too:
def input(self, feature: fmeobjects.FMEFeature):
street = feature.getAttribute('street')
street_fix = ' '.join(map(str.capitalize, street.split(' ')))
feature.setAttribute('street', street_fix)
self.pyoutput(feature)