+6I 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
Best answer by alexbiz
StringReplacer should help clean that up :
Don’t forget to type a space character in the replacement text parameter of the StringReplacer
+32And it would be silly not to recommend the StringConcatenator.😆
+6I 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.
+10I personally wouldn't bother with the StringConcatenator. You can just use an AttributeCreator for this :
+6issue 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.
+10StringReplacer should help clean that up :
Don’t forget to type a space character in the replacement text parameter of the StringReplacer
+10Don’t forget to type a space character in the replacement text parameter of the StringReplacer
;)
+13May be you should consider cleaning up your data using the NullAttributeMapper before sending it or doing the String Concatenation!
Happy FME:-) ing
Cheers
SRG
+10
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
