Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

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
Top Solution Authors