Extract first three words using RegEx?

Hi Rency,

I can't think of a way to limit the results of a Regular Expression.

w+

This expression will return all the words from the input text and store them in a collection.

Then you workflow need only process the first 5 words.

cheers,

Vadim

Vadim is right, you can EXTRACT on words and store into a collection, or SPLIT on whitespace and store into a collection

You can also store the result into a string by matching the first three sets of characters that are followed by a whitespace using

^(w+s+){3}

w - is a word character

s - is a whitespace character

^ - an anchor to match the start of the string

{3} - repeat the match exactly 3 times

To do the opposite and match all other words except the first three you add the ?: to make the first sets a non-capturing group.

^(?:w+s+){3}

If you just want the numbers, you should be able to match them using only d+.

But if you use extract, it will put each digit match into a collection if i'm not mistaken. So maybe you can do the opposite of use Replace text ?:d+, and replace it with blank, then store the result in text var. It should result in 3042016. I didn't test though, let me know if that works.