通过公式从单元格中提取所需的数据 [英] Extract Required Data from the Cell Through Formula

问题描述

我一直在使用下面的公式，该公式从单元格中提取所需的结果，但是现在我试图从该单元格中获取更多的数据，并且我一直试图从该单元格中获取更多的值，但是它不起作用.>

我已经附上了一个Google表格，其中提供了数据和所需的结果以及我的公式.

任何帮助将不胜感激.

  = ArrayFormula(IFERROR(IFERROR(REGEXEXTRACT(A3:A，.*(COMPLETE).*"))，REGEXEXTRACT(A3:A，"^ \ * \ * \ *(.*)?")))) 

https://docs.google.com/spreadsheets/d/1WjpvEfpndRJ-tTOF99mSF9knMyF5Sq_FVpxnnvbgHHg/edit?usp = sharing

解决方案

您的解决方案是一个类似的公式

= ArrayFormula(TRIM(REGEXREPLACE(A3:A，"\.\.\.(.*)| \ * \ * \ *"，，")))

您仅使用 TRIM 拒绝结果开头或结尾的空格.

该公式仅保留 *** 和 ...

之间的所有内容

I have been using below formula which extract the desired result from the cell but now i am trying to get more data from the cell and i have tried at my end to get further values from the cell but its not working.

I have attached a Google Sheet where data and desired result is available and as well my fomrula.

any help will be appreciated.

=ArrayFormula(IFERROR(IFERROR(REGEXEXTRACT(A3:A,".* (COMPLETE) .*"),REGEXEXTRACT(A3:A,"^\*\*\* (.* )? "))))

https://docs.google.com/spreadsheets/d/1WjpvEfpndRJ-tTOF99mSF9knMyF5Sq_FVpxnnvbgHHg/edit?usp=sharing

解决方案

Your solution is a similar formula

=ArrayFormula(TRIM(REGEXREPLACE(A3:A,"\.\.\.(.*)|\*\*\*","")))

You use TRIM only to reject empty spaces from beginning or end of result.

The formula keeps only everything between *** and ...

这篇关于通过公式从单元格中提取所需的数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！