How to Delimit Cells in Formulas

Hi,

I have two columns:

I want the second column to be delimited (trim) at just the release version. Unfortunately, I'm not super experienced with formulas.

While I was able to get this formula to work for 1 row,

it's easy to see how this isn't scalable. I looked for instructions on trimming and delimiting but all the examples I saw had words that you could filter out.

I tried looking for some wildcard functionality but I couldn't find it. Can someone help me with a formula that will strip everything out of the first column except the last 4 characters for placement in the second column?

Find more posts tagged with

Accepted answers

AravindGP

Hi There,

You can have a formula in AFO Version and make it a column formula. The formula would be "=Right([Primary Column]@row, 4)". This formula will pick up the last 4 characters of the text in your primary column.

All comments

AravindGP

Hi There,

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.