I am trying to extract two numeric values from text. One of the values is directly after “$” and varies in length. The next is directly before a word “endpoint” and also varies in length. Here is an example of text:
• $24,200 + Professional Services ARR • 650 endpoints • Blah came to Blah wanting to move away from Blah • Huge shoutout to Blah for helping with Blah and answering all their technical follow up questions.
In this instance, I need 24,200 and 650 each in their own columns.
I am totally lost on how to do this and have been trying for hours. Any help is seriously appreciated.
I agree - that’s the right approach given the constraints of working in a formula. Two observations -
Sometimes it makes sense to avoid this drama by crafting a system that generates discrete values further upstream in the process. Is this possible? Often-times, we create very complex and brittle solutions that are fundamentally unneeded if we did something else better. Elon Musk - “The best part is no part at all.”