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