This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have a field that has products by brand. I would like to split this out to have a 'Brand' field and a 'product field'. The brand is located RIGHT of the second '-'. I am having issues separating these out. See below for current field layout, and desired field outcomes.
There are multiple products and brands within each product, so the number of characters varies. I will need to grab everything to the RIGHT of the second '-' for the Brand column, and everything to the LEFT of the second '-' for the Product column. And then Any idea on how to accomplish this?
Because the number of characters varies and you're more looking for a pattern, I would suggest using RegEx to solve this problem. I actually like to use RegEx in my Formula tools so I would use the following two expressions: