Alteryx Designer Discussions

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

RegEx - Extract a Variable Dollar Value N Characters from a Given Word

Highlighted
11 - Bolide

@Thableaus 

 

I like where you are going with this approach. But, I ran into a snag when I tested it out using regex101.com.  It does not seem to be locking onto the first awarded value pair. 

 

Screen Shot 2019-02-26 at 12.44.54 PM.png

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

@hellyars 

 

Maybe this would work:

 

^.*?awarded.*?\$([\d,]+).*$

 

Cheers,

Highlighted
11 - Bolide

It works -- nice and simple.  Thanks.

Labels