Extracting with Regex a substring-dynamic first word in the string

aviad79

New Member
Hi all.
I have a collection of strings: ["Apples sales-May 2019", "Figs sales-May 2019", "Bananas sales-May 2019", "Coconuts sales-May 2019", "Cherries sales-May 2019"]
all the strings have only 5 different possible substrings as you can see: Apples, Figs, Bananas, Coconuts, Cherries (substring with minimum 4 characters length and a maximum 7 characters)
I'm trying to extract dynamically on a loop the substring with Utility Strings Extended - Regex V2; on the Regex expression I've written: "\w{1,7}" but getting a Syntax error. The token '"\w{1,7}"' is invalid.
Any helpful thoughts ?
Many thanks !
 

Yousiside

New Member
The dynamic nature of the outcome is one advantage of this method. This indicates that if you alter the original text string in the column A cells
 
Top