Skip to main content

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 

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