Extract last string of Characters from a name

Looking to extract the last characters from a name the its preceded with the last underscore.

“Thisisvariable_morecharachtershere_Iwantthistext” = “Iwantthistext”

Hi Tibor,

Try this:
RIGHT({Name}, LEN({Name}) - FIND("_", {Name}, FIND("_", {Name}) + 1))

Make sure you subtract {name} for the name of your column though.

Let me know if it doesn’t work and we can try something else.

Hi Matt!

You have to forgive me but I am a total noob, the formula just seems to duplicate the name, and no matter what I tried to change it would just end up failing, I do appreciate your help though!!

Can you show me a screenshot with the item sad also the formula?

Hi Matt, So thanks again for your time here, Looks like I was not completely precise in the initial request, and I did not test out some variables.(I only had one underscore in my test pulse) So the underscore count is a variable and looking to extract the number after the last one. Hope this is still possible, apologies for the confusion!v
Screenshot 2024-10-02 090929

Hi @tibor,

Try:

REGEXEXTRACT({Name}, "_([^_]*)$")

Want to take your formulas to the next level? Try the Advanced Formula Booster, the app that reinvents formulas in monday.

  • Create formulas without using the Formula column (and avoid its limitations)
  • Build formulas involving data from the previous item, the next item, the sub-items, the parent item, even items in the same group or the same board.
  • In one formula, update multiple columns from multiple items.

Check our blog for real use cases.

1 Like

also, I used the formula you gave direct copy and paste

RIGHT({Name}, LEN({Name}) - FIND(““, {Name}, FIND(””, {Name}) + 1))

Hi :slight_smile:

The code that @GCavin suggested works, if you just want the text after the last “_”.

I didn’t know that monday recognised the regexextract function :heart:

Thanks That works perfectly!!!

I hope this thread helps a bunch more people!!