Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

Alteryx Designer Desktop Discussions

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

Regex parsing help

elamp6
7 - Meteor

Hi there,

I'm trying to extract everything after "Business Name" using this expression: (?<=Business Name).+

 

So for example, if my original sentence is:

This is a Business Name for a new business.

 

I want to see:

 for a new business.

 

Unfortunately, when I put this expression into the Regex tool, it is saying "No Marked Groups Found" when I try to Parse. Is this a problem with the expression?

3 REPLIES 3
Aguisande
15 - Aurora
15 - Aurora

Hi @elamp6 

I'm not the most versed person in Regex, but I think this will do it for you:

Business Name(.+)

OR

Business Name\s(.+) if you don't want the leading space in front of your "extracted string"

 

Remember to use the Parse Method on the Regex Tool.

Hope this helps

KP_DML
8 - Asteroid

This will match everything after, but not include, Business Name:

(?<=Business Name).*

 

https://regexr.com/ is a great site for learning and testing regex expressions.

 

elamp6
7 - Meteor

@Aguisande That'll do it! Much simpler and perfectly effective. Thank you!

Labels