How to reverse order of strings in a column separated by delimeter

manasaMS

I have a column named Country with some values in it separated by the delimeter "|", and i want to revere the order of it.

Eg: The country column has all the below values in a single row separated by delimeter "|"

Australia | Chile | puerto rico | dominican republic | India | Kenya

and i want to reverse the order of these items. The solution i want is

Kenya | India | dominican republic | puerto rico | Chile | Australia

I just want to reverse the order, not reverse the string itself. Please let me know if anyone knows how to solve this. Thanks

Paul Newcome

You would have to use helper columns and a parsing solution to first parse it out across multiple columns (one column for each entry). Then you can use another formula to put them back together in reverse order.