Regex not working for an Extract

Question
1

I am using the Regex <a\b[^>]>(.?) in an Extract. The result for all records is blank. An example of a field content is:
<a href=https://www.audible.com/author/Lucy-Foley/B00LMBVZNC?ref=a_lib_c4_libItem_author_1&pf_rd_p=6a5ce8e4-798e-4a64-8bc5-71dcf66d673f&pf_rd_r=JM39XQWH1PM395Z1NGAX>Lucy Foley

This Regex returns “Lucy Foley” in RegexBuddy but not in Extract. Any ideas?

Thank you.

2

Both only captures a single character. I don’t see how it work in any regex implementation. Perhaps the regex got mangled by this forum (try using ‘preformatted text’)? Presumably you want:

<a\b[^>]*>(.*)

image
image772×519 117 KB

3

regex-extract.transform (1.9 KB)

4

Sorry for the formatting. My original was:

<a\b[^>]*>(.*?)</a>

Looks like the difference was in the capture, mine was a “lazy” and yours was “greedy”. Looks like your implementation doesn’t support lazy. I’m trying to find the right setting to RegexBuddy that matches your implementation.

Thanks so much for the fast reply!

5

Currently we only support greedy (maximal) matching for regular expressions.

6

See also: