Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Register for the upcoming Live Community Q&A Session - and don't forget to submit your questions for @DeanS regarding the future role of analytics here.
SOLVED

REGEX help

Highlighted
8 - 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,

Highlighted
8 - Asteroid

@Thableausthanks, that is good

Labels