Alteryx中带量词的正向后行断言正则表达式失效，求匹配指定内容的改写方案

Got it, let's work through this Alteryx regex problem. The core issue here is that Alteryx's regex engine (built on .NET, with some tool-specific constraints) doesn't allow variable-length quantifiers like + inside positive lookbehind assertions—unlike more permissive online testers that use engines like PCRE2.

The Reliable Fix: Use Capture Groups Instead of Lookbehind #

Instead of relying on a lookbehind to "skip" the preceding text, we can use a capture group to directly target the word we want. This approach works across all Alteryx versions and avoids lookbehind limitations entirely.

Here's the adjusted regex:

Vores\sref.:\s\d+-\d+\s+(\w+)

How it works:

• Vores\sref.:\s: Matches the exact phrase "Vores ref.: " (including the space after the colon)
• \d+-\d+: Matches the hyphenated number pattern like 23244-2234 (one or more digits, a hyphen, one or more digits)
• \s+: Matches one or more spaces between the hyphenated number and your target word
• (\w+): Captures the next sequence of word characters (your desired LW782837673) into Group 1

Using this in Alteryx:

1. Add a Regex Match tool to your workflow
2. Paste the regex above into the "Regular Expression" field
3. Under "Output Method", select "Extract Group 1" (or specify the group index as 1 if using a different tool like Regex Replace)
4. Run the workflow—you'll get your target word as the output.

Why this beats lookbehind for Alteryx: #

Capture groups are far more compatible with Alteryx's regex implementation, and they're easier to debug if you run into edge cases (like extra spaces or variations in the input string).

Example Test: #

For your sample string:

ABC This is an example Vores ref.: 23244-2234 LW782837673 Test 2324324

The regex will capture LW782837673 in Group 1, which is exactly what you need.

内容的提问来源于stack exchange，提问作者Andreas Hjortberg Meyer