In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

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