Cast your vote for the official 2025 Inspire Pin! Designs were submitted by fellow Community members and reflect the creativity and passion of Alteryx users across the globe. Vote now!
Free Trial

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
Top Solution Authors