ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now

Alteryx Designer Discussions

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

Extracting a text string of variable length

DKMI
6 - Meteoroid

I have data which looks like this:

 

Big Data|Business|Business Analysis and Strategy|Business Software and Tools|Continuing Education (CEU)|Core Capability Data Analytics|Core Capability Digitalisation|CPE|Data Analysis|Data Analytics|Data Science|Data Science Careers|NASBA Continuing Professional Education (CPE)|Technology

 

Ultimately, I would like to pull out the characters between the first 'Core Capability' and the subsequent '|'. ie. 'Analytics'.

 

I have been trying .*?CORE CAPABILITY(.*?)/| (and variants thereof)

 

Any help appreciated

 

MarqueeCrew
19 - Altair
19 - Altair

@DKMI 

 

You were CLOSE...

 

regex_replace([Field1],".*?Core Capability (.*?)\|.*",'$1')

 

Cheers,

 

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Please Subscribe to my youTube channel.
DKMI
6 - Meteoroid

You rock!

 

Have an awesome weekend!

Labels