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:
Neither method works in Alteryx
The regular expression works correctly at https://regex101.com/
Can you help me?
Solved! Go to Solution.
Hi @mb1824
The ` character does not need escaping.
REGEX_Replace([Field1],".*`(\w+)\$`","$1")
This should work.
Cheers,
@Thableausthanks, that is good