I need to extract the first segment of a paragraph until it runs into a number. Example: “The marketplace opportunity 5623 Blvd in town and state relevant.”
I need to extract only “The marketplace opportunity”. The data will be different each time but I will have to always extract only the data to the left of the first number.
Any idea of an activity or code to use for this?