The EXTRACT function uses regular expressions which can include groups, but it returns only the whole matching string, not the groups. Instead, it should return one column for each match, or at least return the value of the first group.
Test case: Buckeye corpus, query string ible, string function EXTRACT(Transcript, "([AEIOU].) B [\w\s]{0,2}.?L$").
This returns IH B EL for P AA S IH B EL. Instead, it should return IH.
The EXTRACT function uses regular expressions which can include groups, but it returns only the whole matching string, not the groups. Instead, it should return one column for each match, or at least return the value of the first group.
Test case: Buckeye corpus, query string
ible
, string functionEXTRACT(Transcript, "([AEIOU].) B [\w\s]{0,2}.?L$")
.This returns
IH B EL
forP AA S IH B EL
. Instead, it should returnIH
.