Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
解決済み

Extract third and fourth word from sentense

SH_94
ボリード

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件の返信2
ShankerV
キャスター

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.
投票
We’re dying to get your help in determining what the new profile picture frame should be this Halloween. Cast your vote and help us haunt the Community with the best spooky character.
Don’t ghost us—pick your favorite now!
ラベル