I 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 ?
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.
Thank you! That was super easy to implement and worked perfectly.
You 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
You 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!😎