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

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

2 REPLIES 2
DataNath
17 - Castor

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

 

1.png

RajatRehria
8 - Asteroid

Many thanks @DataNath for the solutions

Labels