I am trying to concatenate 6-7 fields to create single field with spaces in-between different field values to create a address like string, no commas needed. Can I do it in text editor?
Field1 Field2 Field3
original: 123 ABC Street
Filed Combined
Target: 123 ABC Street
Page 1 / 1
Hi @nikkik I think in your case the Aggregator will work well.
And it would be silly not to recommend the StringConcatenator.
I am using String concatenator but it doesn’t place space between different fields it comes as one string like
123ABCStreet
Thanks!
If you are using the StringConcatenator with Basic mode, you can select “Constant” in the String Type column to insert any character(s) including a space literally.
I personally wouldn't bother with the StringConcatenator. You can just use an AttributeCreator for this :
issue i am facing is there are nulls in some fields and i am getting unnecessary space in-between how do i solve it so the final field values comes correctly. example below. lots of space between number and street name because field between them have null.
StringReplacer should help clean that up :
Don’t forget to type a space character in the replacement text parameter of the StringReplacer
it is removing all the spaces and not just extra.
Thanks!
Don’t forget to type a space character in the replacement text parameter of the StringReplacer
;)
@nikkik
May be you should consider cleaning up your data using the NullAttributeMapper before sending it or doing the String Concatenation!
Happy FME:-) ing
Cheers
SRG
@raghavendrans Unfortunately this will do nothing, since the spaces are not values of the attributes.
Thank you for your help everyone!
I got the results I needed, shout out to @alexbiz.