Free Trial

Alteryx Designer Desktop Discussions

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

Extracting text from row

Tid14
8 - Asteroid

Hi, i have to extract text (Fund Names) from rows and then take those into seperate column. 

 

The text in the column is:

3010208700NVIT Multi sector bond fund

3028799888NVIT Columbia overseas value fund

 

I want to extract starting from NVIT till fund 

 

IMG_20210930_205429__01.jpg

3 REPLIES 3
apathetichell
19 - Altair

REGEX_Replace([field1],".*NVIT\s(.*)\sFund","$1")

atcodedog05
22 - Nova
22 - Nova

Hi @Tid14 

 

Here is how you can do it.

Workflow:

atcodedog05_0-1633016101857.png

 

Hope this helps : )

apathetichell
19 - Altair

@atcodedog05Good job reading that section that the poster wanted to include NVIT and Fund...

Labels
Top Solution Authors