Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Extract third and fourth word from sentense

SH_94
11 - Bolide

Hi community,

 

i would like to ask how to extract the following details for the input below and attached with desired output.

 

Basically i would like to extract third and fourth words from the sentence and the desired output as below.

 

SH_94_0-1676093148731.png

 

Thank you for the support.

 

 

 

2 REPLIES 2
ShankerV
17 - Castor

Hi @SH_94 

 

One way of doing this!!!!

ShankerV_0-1676095260079.png

 

Many thanks

Shanker V

 

MarqueeCrew
20 - Arcturus
20 - Arcturus

@SH_94 

 

Easy to use getword(). Just remember that the first word is zero. 

getword([input],2) + " " + getword([input],3)

 

 cheers

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
Labels