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

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 "|"

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

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

Find more posts tagged with

Formulas

Accepted answers

All comments

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.