+4I have a string column containing lake names in the format ''Blue, Lake'' and I would like to reverse the format to ''Lake Blue''. I somehow can't find a way to reverse a string at the comma.
Is there an easy way to accomplish this using string functions in FME ?
Best answer by dustin
I would use an AttributeSplitter to split on the comma, which will create a list. Then in an AttributeCreator, build your new attribute using the list elements.
+31I would use an AttributeSplitter to split on the comma, which will create a list. Then in an AttributeCreator, build your new attribute using the list elements.
+4Thank you! That was super easy to implement and worked perfectly.
+44You could also use a StringReplacer, match the word before the comma in one group and the word after the comma in another group and then replace with the matched groups in reverse order
+31You could also use a StringReplacer, match the word before the comma in one group and the word after the comma in another group and then replace with the matched groups in reverse order
That is slick!😎
