Extract text

Mary Kam

I have text that needs to be extracted however I want to combine 2 of my formulas

This is the helper column =(LEFT(JOB@row + " ", FIND(" ", JOB@row + " ") - 1))

=IFERROR((MID([STUDY HELP]@row, (1 + FIND("-", [STUDY HELP]@row)), 1000)), "")

The text looks something like this:

text-74272998 9 months to grow flowers

I am trying to extract just the numbers that varies in quantity of characters

Also the text can sometimes be text-7879.sp.

In which case I would like the result to be 7879.sp

Thanks

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

Are you able to provide screenshots for context?

Mary Kam

for 74272999.sp. I just want 74272999.sp I do not want a period at the end

Paul Newcome

Give this a try:

=SUBSTITUTE(original_formula, ".sp.", ".sp")

Mary Kam

It worked. But is there a way to combine the 2 formulas so I do not need a helper column.

Paul Newcome

Wherever you have a reference to the helper column, just drop the formula from the helper column in.

=[Column A]@row + 53

=formula_from_column_A + 53

Mary Kam

It worked. Thanks for the quick response.

Paul Newcome

Happy to help. 👍️

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.