Hello,
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
FIELD VALUE
Description / Description : PRODUCT 123
Item / Art. : 1234567
UPC / CUP : 12345678912
Retail / P. det. : $1.87
Size / Format : 181g
Description / Description : PRODUCT 1234
Item / Art. : 2345678
UPC / CUP : 12345678912
Retail / P. det. :$3.41
Size / Format : 78g
Description / Description :PRODCT 789
Item / Art. :9876543
UPC / CUP :098765432109
Retail / P. det. :$1.98
Size / Format : 213g
