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