Looking to extract the last characters from a name the its preceded with the last underscore.
“Thisisvariable_morecharachtershere_Iwantthistext” = “Iwantthistext”
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
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.
Check our blog for real use cases.
also, I used the formula you gave direct copy and paste
RIGHT({Name}, LEN({Name}) - FIND(““, {Name}, FIND(””, {Name}) + 1))
Hi
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
Thanks That works perfectly!!!
I hope this thread helps a bunch more people!!