REGEX help

[mb1824]

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?

[Thableaus · Accepted solution]

Hi @mb1824 

The ` character does not need escaping.

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

This should work.

Cheers,

[mb1824]

@Thableausthanks, that is good