Find part of string and get everything to the left

I’m not sure how I can do this. I have a string:

"101 7th Avenue New York, New York Size: 56,870 SF Status: Operating Property Available Spaces: 1 Pads: 0 101 7th Avenue
** New York, NY 10011"**

and I want to find the word “Size:” and put everything to the left of it into a variable. I tried to regex split it but I’m not great with writing the code out. Can someone assist me?

Hi @atarantino ,

Could you give a try with the Split method :


thank you for this

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.