We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Reg Parsing Inconsistent

Qiu
21 - Polaris
21 - Polaris

I usually use https://regex101.com/ to test my Reg expressions, and so far it works fine.

Today I run into an inconsistency between Alteryx and it.

Any ideas?


Reg1.PNG

4 REPLIES 4
jdunkerley79
ACE Emeritus
ACE Emeritus

I think it is due to escaping the <  and >. They match if you don't:

<.+>(.+)<.+><.+>

 

I would normally be slightly careful on such parses:

<[^>]+><[^>]+>(.+)<\/[^>]+><\/[^>]+>

 but clearly depends on that data!

 

vizAlter
12 - Quasar

Hi @Qiu — Try this one:

(.*=./)(.*\">)([\w\s]+)(.*$)

 

vizAlter_0-1601373212515.png

 

vizAlter
12 - Quasar

@Qiu — Thank you!  🙂

Qiu
21 - Polaris
21 - Polaris

@jdunkerley79  @vizAlter 
Thank both of you so much. I guess I need to be more carefull about this and learn more about the Reg. Exp.

Labels
Top Solution Authors