community
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Fireball

@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

Alteryx Certified Partner
Alteryx Certified Partner

@hellyars 

 

Maybe this would work:

 

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

 

Cheers,

Fireball

It works -- nice and simple.  Thanks.

Labels