在数组中使用 REGEXEXTRACT，搜索多列 [英] Using REGEXEXTRACT in an array, searching multiple columns

问题描述

谁能告诉我我在这个公式中做错了什么?

Can someone please tell me what I am doing wrong in this formula?

=ARRAYFORMULA(REGEXEXTRACT((A2:A&"")+(B2:B&"")+(C2:C&"")), "02(\d{14})37")

我正在尝试提取一个 02 到 37 之间的 14 位数字，该数字可能位于 A 列、B 列或 C 列中.

I'm trying to extract a 14 digit number that sits between 02 and 37 that may be in columnA, columnB or columnC.

我也试过了，预期结果只显示在第一行:

I've tried this also, with the expected result showing on the first row only:

=ARRAYFORMULA(REGEXEXTRACT(textjoin(" ",true,A2:C),"02(\d{6,14})37"))

我真的很困惑.

推荐答案

应该是这样的:

=ARRAYFORMULA(IFERROR(IFERROR(IFERROR(IFERROR(
 REGEXEXTRACT(A2:A&"", "02(\d{14})37"), 
 REGEXEXTRACT(B2:B&"", "02(\d{14})37")),   
 REGEXEXTRACT(C2:C&"", "02(\d{14})37")))))

这篇关于在数组中使用 REGEXEXTRACT，搜索多列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！