简单的自动化示例——用代码做表格计算和文本整理

const text = `日期,品名,数量,单价
2026-03-01,铅笔,10,500
2026-03-01,笔记本,3,2000
2026-03-02,铅笔,5,500
2026-03-02,橡皮,4,300`;

const lines = text.trim().split("\n");
console.log(lines[0].split(","));

const rows = lines.slice(1).map((line) => {
  const c = line.split(",");
  return {
    date: c[0],
    item: c[1],
    qty: Number(c[2]),
    price: Number(c[3]),
  };
});
console.log(rows.length);
console.log(rows[0]);

[ '日期', '品名', '数量', '单价' ]
4
{ date: '2026-03-01', item: '铅笔', qty: 10, price: 500 }

const c = "2026-03-01,铅笔,10,500".split(",");
console.log(c[2] + c[3]);
console.log(Number(c[2]) * Number(c[3]));
console.log(Number("10个"));

10500
5000
NaN

const rows = [
  { item: "铅笔", qty: 10, price: 500 },
  { item: "笔记本", qty: 3, price: 2000 },
  { item: "铅笔", qty: 5, price: 500 },
  { item: "橡皮", qty: 4, price: 300 },
];

let total = 0;
let qtySum = 0;
const byItem = {};
for (const r of rows) {
  const amount = r.qty * r.price;
  total += amount;
  qtySum += r.qty;
  byItem[r.item] = (byItem[r.item] || 0) + amount;
}
console.log("总销售额", total);
console.log("平均数量", qtySum / rows.length);
console.log(byItem);

总销售额 14700
平均数量 5.5
{ '铅笔': 7500, '笔记本': 6000, '橡皮': 1200 }

const raw = [
  "  小明 ",
  "王  芳",
  "小明",
  "",
  "张伟   ",
  "王 芳",
];
const cleaned = raw
  .map((s) => s.trim().replace(/\s+/g, " "))
  .filter((s) => s !== "");
console.log(cleaned);

const unique = [...new Set(cleaned)];
console.log(unique);
console.log(raw.length, "→", unique.length);

[ '小明', '王 芳', '小明', '张伟', '王 芳' ]
[ '小明', '王 芳', '张伟' ]
6 → 3

const emails = ["[email protected]", "[email protected] "];
const norm = emails.map((e) => e.trim().toLowerCase());
console.log([...new Set(norm)]);

[ '[email protected]' ]

function formatPhone(s) {
  const d = s.replace(/\D/g, "");
  if (d.length !== 11 || !d.startsWith("01")) {
    return null;
  }
  return d.slice(0, 3) + "-" + d.slice(3, 7) +
    "-" + d.slice(7);
}

const inputs = [
  "010-1234-5678",
  "01012345678",
  "010 1234 5678",
  "(010)1234.5678",
  "1234-5678",
];
for (const p of inputs) {
  console.log(p, "→", formatPhone(p));
}

010-1234-5678 → 010-1234-5678
01012345678 → 010-1234-5678
010 1234 5678 → 010-1234-5678
(010)1234.5678 → 010-1234-5678
1234-5678 → null

// 只检查月1~12、日1~31（拦不住2月30日）
function formatDate(s) {
  const t = s.replace(/\s/g, "").replace(/\.$/, "");
  const parts = t.split(/[.\/-]/).map(Number);
  if (parts.length !== 3) return null;
  const y = parts[0], m = parts[1], d = parts[2];
  if (!Number.isInteger(y) || y < 1000) return null;
  if (!(m >= 1 && m <= 12 && d >= 1 && d <= 31)) {
    return null;
  }
  const mm = String(m).padStart(2, "0");
  const dd = String(d).padStart(2, "0");
  return y + "-" + mm + "-" + dd;
}

const dates = [
  "2026.3.5.",
  "2026/03/05",
  " 2026-3-15 ",
  "2026. 12. 1",
  "2026.13.1",
  "3/5/2026",
];
for (const x of dates) {
  console.log(JSON.stringify(x), "→", formatDate(x));
}

"2026.3.5." → 2026-03-05
"2026/03/05" → 2026-03-05
" 2026-3-15 " → 2026-03-15
"2026. 12. 1" → 2026-12-01
"2026.13.1" → null
"3/5/2026" → null

const line = '2026-03-03,"铅笔, 蓝色",2,500';
const cells = line.split(",");
console.log(cells.length);
console.log(cells);

5
[ '2026-03-03', '"铅笔', ' 蓝色"', '2', '500' ]

const text = "姓名,金额\r\n小明,3000\r\n\r\n小红,abc\r\n";
const lines = text.split(/\r?\n/).slice(1);
const ok = [];
const bad = [];
for (const line of lines) {
  if (line.trim() === "") continue;
  const c = line.split(",");
  const n = Number(c[1]);
  if (c.length === 2 && Number.isFinite(n)) {
    ok.push({ name: c[0], amount: n });
  } else {
    bad.push(line);
  }
}
console.log("已处理", ok.length, "待定", bad.length);
console.log(bad);

已处理 1 待定 1
[ '小红,abc' ]