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.

Extracting a text string of variable length

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


19 - Altair
19 - Altair



You were CLOSE...


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





Alteryx ACE & Top Community Contributor

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

You rock!


Have an awesome weekend!