Alert: There is a planned Community maintenance outage October 16th from approximately 10 - 11 PM PST. During this time the Alteryx Community will be inaccessible. Thank you for your understanding!
community Alteryx IO Mission Control
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Designer Desktop Discussions

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

Extraction from srting

RajatRehria
8 - Asteroid
‎09-20-2023 04:55 AM

Hi guys, i want to extract first 4 words from a column using formula tool, kindly help. Thanks.

 

Input:

ABC Investment fund Ltd.

XYZ Corporate fund private LLC

Gold Mine fund (New) pvt. Ltd

 

Desired output:

ABC Investment fund

XYZ Corporate fund

Gold Mine fund

Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

2 REPLIES 2
DataNath
17 - Castor
‎09-20-2023 05:14 AM

Hey @RajatRehria, there's a bunch of ways to do this - here's a few I can think of immediately:

 

1.png

Parse first 3 words.yxmd
Reply
RajatRehria
8 - Asteroid
‎09-20-2023 05:47 AM

Many thanks @DataNath for the solutions

Reply
Labels