英文:
Check if each non-blank line of text inside a cell ends with a date string. "(Completed mm/dd/yy)"
问题
这涉及到一些正则表达式工作。单元格中的每一行文本都由一个空行分隔。
英文:
I assume this involves some REGEX work. Each separate line of text in a cell is separated by a blank line.
答案1
得分: 2
你可以尝试:
=BYROW(C4:C, LAMBDA(in, IF(in="", , LET(_in, SPLIT(in, CHAR(10)), COUNTA(IFNA(FILTER(_in, REGEXMATCH(_in, "Completed \d{1,2}/\d{1,2}/\d{2}"))))=COUNTA(_in))))))
这实质上是通过换行符CHAR(10)
进行拆分,筛选包含Completed mm/d/yy
的值,并检查筛选后的值的数量是否与未筛选的值的数量相同。
英文:
You could try:
=BYROW(C4:C,LAMBDA(in,IF(in="",,LET(_in,SPLIT(in,CHAR(10)),COUNTA(IFNA(FILTER(_in,REGEXMATCH(_in,"Completed \d{1,2}/\d{1,2}/\d{2}"))))=COUNTA(_in)))))
This is essentially splitting by the newline CHAR(10)
, filtering the values that contain Completed mm/d/yy
and checking if the count of the filtered values is the same as the count of the unfiltered values.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库,让每个人都能够通过互相帮助和分享经验来进步。
评论