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 text field that contains multiple details (example below). I would like to query this field for the string "Item / Art" and return what follows after the semi-colon. It should return every instance of this. It will vary how many times the string "Item / Art" appears in the field.
See field value below. It should return the following in one field separated by a comma: 1234567, 2345678, 9876543
I realize my initial question wasn't as clear as it could be. Please see attached. The field value I provided is one cell value. There can/will be multiple cells with similar structure, but could have any number of descriptions / item numbers, etc. within. I have attached this for clarity.