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 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?

 

 

Alteryx Certified Partner
Alteryx Certified Partner

Hi @mb1824 

 

The ` character does not need escaping.

 

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

 

This should work.

 

Cheers,

Highlighted
Asteroid

@Thableausthanks, that is good

Labels