+18I have a spreadsheet with Address, Street Name, City, and Zip Code fields with 500 addresses. I need to create mailing labels for each address in this format:
Occupant
1234 Main St
City A, 54433
The output would be a Word/Text doc with the list of labels.
What Transformer(s) would be used to create these?
Best answer by j.botterill
In attributeManager, create a new output attribute and in the value > open text editor - as you would expect - allows you to construct a text value. It includes all the usual string-handling functionality you would need, such as concatenation, trimming, padding, and case-changing
Here the user is constructing an address string by concatenating various existing attributes with some fixed characters (the commas).
+64The StringConcatenator or AttributeManager will be able to combine all the individual attributes together to form that required format
https://docs.safe.com/fme/html/FME-Form-Documentation/FME-Transformers/Transformers/stringconcatenator.htm
https://docs.safe.com/fme/html/FME-Form-Documentation/FME-Transformers/Transformers/attributemanager.htm
+53In attributeManager, create a new output attribute and in the value > open text editor - as you would expect - allows you to construct a text value. It includes all the usual string-handling functionality you would need, such as concatenation, trimming, padding, and case-changing
Here the user is constructing an address string by concatenating various existing attributes with some fixed characters (the commas).
