feat(formula): regexextract/regexmatch/regexreplace

[wpxp123456]

close dream-num/univer-pro#2328

Pull Request Checklist

• Related tickets or issues have been linked in the PR description (or missing issue).
• Naming convention is followed (do please check it especially when you created new plugins, commands and resources).
• Unit tests have been added for the changes (if applicable).
• Breaking changes have been documented (or no breaking changes introduced in this PR).

[github-actions]

View Deployment

📑 Examples	📚 Storybook
🔗 Preview link	🔗 Preview link

[codecov]

Codecov Report

Attention: Patch coverage is 75.54348% with 90 lines in your changes missing coverage. Please review.

Project coverage is 31.27%. Comparing base (50ab0c3) to head (6402b26).
Report is 1 commits behind head on dev.

Files with missing lines	Patch %	Lines
...es/engine-formula/src/engine/utils/regexp-check.ts	66.78%	90 Missing ⚠️

Additional details and impacted files

@@            Coverage Diff             @@
##              dev    #3282      +/-   ##
==========================================
+ Coverage   31.13%   31.27%   +0.13%     
==========================================
  Files        2254     2258       +4     
  Lines      116682   117050     +368     
  Branches    25641    25757     +116     
==========================================
+ Hits        36325    36603     +278     
- Misses      80357    80447      +90     

☔ View full report in Codecov by Sentry.
📢 Have feedback on the report? Share it here.

[Gggpound]

回溯咋办？

[oumomomo]

REGEXMATCH函数：
单元格内输入=REGEXMATCH("13912345678", "^1[3456789]\d{9}$")，结果不一致

[univer-bot]

Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑‍🤝‍🧑👫🧑🏿‍🤝‍🧑🏻👩🏾‍🤝‍👨🏿👬🏿

REGEXMATCH function:
Enter =REGEXMATCH("13912345678", "^1[3456789]\d{9}$") in the cell, but the results are inconsistent

[oumomomo]

REGEXEXTRACT函数

1、单元格内输入=REGEXEXTRACT(B10,"[a-Z]+")/=REGEXEXTRACT("abcd","((((a")，计算结果未报错

2、飞书模板内的两条示例D列公式计算不出结果，C4单元格 计算错误
样张：https://xakbyahbro.feishu.cn/sheets/OV5ksD5z6hiJ9ktlmREcU5OonVd

3、C3单元格为false时，计算结果报错
样张：https://xakbyahbro.feishu.cn/sheets/OS3SsEdiFheHcktl770coreSnBg?sheet=bq4UIE

4、单元格内输入=REGEXEXTRACT("我的生日20220104","生日(2022\d+)")/=REGEXEXTRACT("我的生日20220104","生日(?:2022)(\d+)")，计算结果错误

5、单元格内输入=REGEXEXTRACT("111aaa111","(\d+)([a-z]+)(\d+)") ，计算结果不对

6、 单元格内输入=REGEXEXTRACT("abcd","((((a)b)c)d)")，计算结果为空

7、D1=The total is $123.45 or €987.65 单元格内输入=REGEXEXTRACT(D1, "[$€]\d{1,3}(,\d{3})*(.\d{2})?") 错误码不一致

8、E1等于Visit our website at https://www.example.com 单元格内输入=REGEXEXTRACT(E1, "https?://[^\s]+") 计算不出结果

[univer-bot]

Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑‍🤝‍🧑👫🧑🏿‍🤝‍🧑🏻👩🏾‍🤝‍👨🏿👬🏿

REGEXEXTRACT function

1. Enter =REGEXEXTRACT(B10,"[a-Z]+")/=REGEXEXTRACT("abcd","((((a") in the cell, and no error will be reported in the calculation result
   

2. The two example formulas in column D in the Feishu template cannot calculate the result, and the calculation in cell C4 is wrong.
   Samples: https://xakbyahbro.feishu.cn/sheets/OV5ksD5z6hiJ9ktlmREcU5OonVd
   
   

3. When cell C3 is false, the calculation result will report an error.
   Sample sheet: https://xakbyahbro.feishu.cn/sheets/OS3SsEdiFheHcktl770coreSnBg?sheet=bq4UIE
   

4. Enter =REGEXEXTRACT("My birthday 20220104","Birthday(2022\d+)")/=REGEXEXTRACT("My birthday 20220104","Birthday(?:2022)(\d+)") in the cell, Calculation result is wrong
   
   

5. Enter =REGEXEXTRACT("111aaa111","(\d+)([a-z]+)(\d+)") in the cell, and the calculation result is incorrect.
   

6. Enter =REGEXEXTRACT("abcd","((((a)b)c)d)") in the cell, and the calculation result is empty.
   

7. D1=The total is $123.45 or €987.65 Enter in the cell=REGEXEXTRACT(D1, "[$€]\d{1,3}(,\d{3})*(.\d{2}) ?") Error codes are inconsistent

8. E1 is equal to Visit our website at https://www.example.com. Enter =REGEXEXTRACT(E1, "https?://[^\s]+") in the cell. The result cannot be calculated.
   

[oumomomo]

REGEXREPLACE函数
1、单元格内输入=REGEXREPLACE("Sheets","e{2}","X")，计算结果不对

2、单元格内输入=REGEXREPLACE("The event will be held on June 15, 2024.", "\b(?:Jan(?:uary)?|Feb(?:ruary)?|Mar(?:ch)?|Apr(?:il)?|May|Jun(?:e)?|Jul(?:y)?|Aug(?:ust)?|Sep(?:tember)?|Oct(?:ober)?|Nov(?:ember)?|Dec(?:ember)?)\s+\d{1,2},\s+\d{4}\b", "[REDACTED]") 计算结果不对

[univer-bot]

Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑‍🤝‍🧑👫🧑🏿‍🤝‍🧑🏻👩🏾‍🤝‍👨🏿👬🏿

REGEXREPLACE function

1. Enter =REGEXREPLACE("Sheets","e{2}","X") in the cell, and the calculation result is incorrect.
   

2. Enter =REGEXREPLACE("The event will be held on June 15, 2024.", "\b(?:Jan(?:uary)?|Feb(?:ruary)?|Mar(?:ch) in the cell )?|Apr(?:il)?|May|Jun(?:e)?|Jul(?:y)?|Aug(?:ust)?|Sep(?:tember)?|Oct(?:ober )?|Nov(?:ember)?|Dec(?:ember)?)\s+\d{1,2},\s+\d{4}\b", "[REDACTED]") The calculation result is incorrect
   

[Dushusir]

Use English comment

[github-actions]

Playwright test results

 14 passed

Details

 14 tests across 8 suites
 3 minutes, 22 seconds
 6402b26
 For more information, see full report