topic Re: String extraction to include words around a specific word in Alteryx Designer Desktop Discussions

String extraction to include words around a specific word

Josk — Thu, 13 Jun 2024 21:43:13 GMT

Hello,

I would like extract a part of a sentence around a key word.

For example:

Input:

1. John wants to buy 5 apples today in the market.

2. There are three apples in the fruit bowl.

3. The red apples fell from the tree.

Output:

1. buy 5 apples today in

2. are three apples in the

3. The red apple fell from

Sometimes there could be a number before the term apple or a full word, but ideally I would like to extract 2 either words or numbers (a number with multiple digits should cound as one number) and 2 words after and of course include the word apples.

Thanks in advance,

Joseph

Re: String extraction to include words around a specific word

Simha — Wed, 04 Mar 2020 16:47:49 GMT

Hi,

Could this solution work?

Simha

Re: String extraction to include words around a specific word

MeaganP — Thu, 05 Mar 2020 05:20:36 GMT

People with more skill can probably make this neater, but this seems to work:

\<\w+\>\s\<\w+\>\sapples\s\<\w+\>\s\<\w+\>

Re: String extraction to include words around a specific word

Josk — Thu, 05 Mar 2020 13:27:17 GMT

Hi Meagan,

I tried what you suggested but got the following error:

Thanks,

Joseph

Re: String extraction to include words around a specific word

MeaganP — Thu, 05 Mar 2020 22:23:20 GMT

This is what I have:

There might be a better way, but 'm putting the section we want into a new column then removing the whitespace and selecting only that column

Re: String extraction to include words around a specific word

Josk — Fri, 06 Mar 2020 08:22:34 GMT

Thanks Simha! This seems to work.

Re: String extraction to include words around a specific word

Simha — Fri, 06 Mar 2020 14:03:33 GMT

You are welcome @Josk. I am glad it helped you.

Simha