I 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?
The 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
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).