Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

REGEX help

mb1824
9 - Comet

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?

 

 

2 REPLIES 2
Thableaus
17 - Castor
17 - Castor

Hi @mb1824 

 

The ` character does not need escaping.

 

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

 

This should work.

 

Cheers,

mb1824
9 - Comet

@Thableausthanks, that is good

Labels