i have some cells contains
Aaaa||ccc||ddd||bb||fff
i would like to reverse them in case condition happens to get
fff|||bb||||ddd||ccc||Aaaa
FME 2021
Thanks in advance
i have some cells contains
Aaaa||ccc||ddd||bb||fff
i would like to reverse them in case condition happens to get
fff|||bb||||ddd||ccc||Aaaa
FME 2021
Thanks in advance
If I understand correctly, you have some data in one attribute, where you want to invert the order of the words. It is not clear why there are extra | characters in your desired results, I ignored those for now.