类似excel实现文本中带数字的值进行规律填充[前提：字符串中数字对数相等](-)

最新推荐文章于 2024-09-27 14:28:55 发布

骑着蜗牛追星星呐

最新推荐文章于 2024-09-27 14:28:55 发布

阅读量234

点赞数

分类专栏：前端 JavaScript 文章标签：算法 js 字符串

本文链接：https://blog.csdn.net/qq_43320162/article/details/106685341

版权

前端同时被 2 个专栏收录

6 篇文章 0 订阅

订阅专栏

JavaScript

5 篇文章 0 订阅

订阅专栏

接收字符串列表，返回填充规则
对所有数值进行规则填充

getTextFillRule = (textList) => {
    let textNumberMatrix = [];
    let RemainTextMatrix = [];
    textList.forEach(textString => {
      let newTextString = textString || '';
      let Matrix = newTextString.match(/\d+/g) || [];
      textNumberMatrix.push(Matrix);
      Matrix.forEach(item => {
        newTextString = newTextString.replace(item, '');
      });
      RemainTextMatrix.push(newTextString);
    });
    let remainSame = RemainTextMatrix.every(item => item === RemainTextMatrix[0]);
    if (remainSame) {
      let textNumber0Len =textNumberMatrix[0].length;
      let isSquareMatrix = textNumberMatrix.every(item => item.length === textNumber0Len);
      if (isSquareMatrix) {
        let textNumberMatrixT = [];
        textNumberMatrix.forEach((item, index) => {
          item.forEach((v, i) => {
            if (index === 0) {
              textNumberMatrixT[i] = [];
            }
            textNumberMatrixT[i][index] = v;
          });
        });
        let rules = [];
        textNumberMatrixT.forEach(item => {
          let value1 = Number(item[1]);
          let value0 = Number(item[0]);
          if (this.isArithmeticSequence(item)) { // 判断是否时等差数列。等差数列虽然也可以用最小二乘实现， 但是等差快一些
            rules.push(({ n }) => {
              return n * (value1 - value0) + value0;
            });
          } else {
            rules.push(this.getLeastSquares(item.map(value => Number(value)))); // 获取最小二乘结果的函数， 可用库或者自己实现
          }
        });
        return ({ n }) => {
          let newString = textList[0] || '';
          rules.forEach((item, index) => {
            let baseNumber = textNumberMatrix[0][index];
            let replaceValue = baseNumber[0] === '0' ? `0${item({ n })}` : item({ n });
            newString = newString.replace(baseNumber, replaceValue);
          });
          return newString;
        };
      }
    }
    return ({ value }) => { 
      return value; 
    };
  }
  ```