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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Community v19.6

Looks aren't everything... But the latest Community refresh looks darn good!

Learn More
SOLVED

REGEX help

Asteroid

Hi,

 

Per the attached workflow, I am trying to parse the below string to extract the sheet name, 86

 

C:\Temp\MASTERLIST.xlsm|||`86$`

 

I have tried:

  • A formula tool with REGEX_Replace([FileName],".*\`(\w*)\$\`","$1")
  • The RegEx tool with the same regular expression input and output method as Replace & Parse

 

Neither method works in Alteryx

 

The regular expression works correctly at https://regex101.com/

 

Can you help me?

 

 

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Hi @mb1824 

 

The ` character does not need escaping.

 

REGEX_Replace([Field1],".*`(\w+)\$`","$1")

 

This should work.

 

Cheers,

Asteroid

@Thableausthanks, that is good

Labels