How to extract the Row # digits from the Predecessor column

Berto D

Here are some samples of what I have...

19FS -2d (I want to extract "19")

17SS (I want to extract "17")

762SS, 22FF (I want to extract "76" to one cell and "22" to another cell)

Any ideas?

Find more posts tagged with

Formulas

Accepted answers

All comments

Neil Watson

I am sure there are more elegant ways, this is how I do it:

=VALUE(IF(CONTAINS("FS", [Primary Column]@row), MID([Primary Column]@row, 1, FIND("FS", [Primary Column]@row) - 1)))

=VALUE(IF(CONTAINS("SS", [Primary Column]@row), MID([Primary Column]@row, 1, FIND("SS", [Primary Column]@row) - 1)))

=VALUE(SUBSTITUTE(IF(CONTAINS("FF", [Primary Column]@row), MID([Primary Column]@row, FIND(", ", [Primary Column]@row) + 2, 100)), "FF", ""))

Berto D

Thank you so much for this. There may be a way to combine all three structures and produce the results in one cell with the JOIN function in a column that is formatted as a Dropdown with multiple values per cell.

I'll give it a try and see if I can figure it out.

Will let you know how it goes.

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.