CITY STREET BLD_NUMBER
1. New-York 42 street 150
2. Albany null 17
and strings wich i got
[CITY:New-York, STREET:42 street, BLD_NUMBER:150] - ok, that's what i need
[CITY:Albany, STREET:, BLD_NUMBER:150] - but i need string like this [CITY:Albany, BLD_NUMBER:150]
the question is how to get what i need? Thanks for answers
+2If it's just Street that could be empty on the concatenated string use a StringReplacer with Text to find
STREET:,
replacing with nothing
here is a simple Python script that will concatenate an arbitrary list of attributes, ignoring empty attribute values (NULL or empty string).
-----
import fmeobjects def FeatureProcessor(feature): to_concatenate = ("CITY", "STREET", "BLD_NUMBER") # Modify as needed join_string = "," # Modify as needed result = join_string.join([feature.getAttribute(attr) \\ for attr in to_concatenate if feature.getAttribute(attr)]) feature.setAttribute("CONCATENATED", result)
-----
Modify the variable "to_concatenate" so that it contains the names of all the attributes to join (case sensitive!) and modify "join_string" to whatever delimiter you desire, either a single character or a string.
For the PythonCaller, add "CONCATENATED" to the parameter "Attributes to expose".
Sample results:
`CONCATENATED' has value `Albany,17'
`CONCATENATED' has value `New-York,42 street,150'
David
I like idea with NullAttributeRemover, but i don't know how to insert in string field's name constant of attribute that can be or not after NullAttributeRemover.
Maybe here possible use an user parameter which contain all attributes of feature or something like this. I am new one to FME and not sure about it.
Anyway, thanks for answers.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
