Skip to content

Open-source manufacturing ERP, MES and QMS. Quoting, MRP, inventory, shop floor, quality and lot/serial traceability on one Postgres schema, with a REST API and MCP server. Self-host or use Carbon Cloud.

1.3 KB
Raw Blame
// SPDX-License-Identifier: AGPL-3.0-only
// Carbon (github.com/crbnos/carbon). Modified or adapted versions of this file,
// including ports, remain AGPLv3; serving them over a network requires releasing their source.

import { describe, expect, it } from "vitest";
import { stripCsvFormulaPrefix } from "./bom";

describe("stripCsvFormulaPrefix", () => {
  it("strips formula-leading characters from non-numeric strings", () => {
    expect(stripCsvFormulaPrefix('=cmd|" /C calc"!A0')).toBe(
      'cmd|" /C calc"!A0'
    );
    expect(stripCsvFormulaPrefix("+SUM(A1:A2)")).toBe("SUM(A1:A2)");
    expect(stripCsvFormulaPrefix("-HYPERLINK(...)")).toBe("HYPERLINK(...)");
    expect(stripCsvFormulaPrefix("@evil")).toBe("evil");
  });

  it("strips prefixes hidden behind leading whitespace", () => {
    expect(stripCsvFormulaPrefix("  =1+1")).toBe("1+1");
    expect(stripCsvFormulaPrefix("\t@evil")).toBe("evil");
  });

  it("leaves numeric strings and negative numbers untouched", () => {
    expect(stripCsvFormulaPrefix("-5.5")).toBe("-5.5");
    expect(stripCsvFormulaPrefix("100")).toBe("100");
  });

  it("leaves ordinary values untouched", () => {
    expect(stripCsvFormulaPrefix("Raw Materials")).toBe("Raw Materials");
    expect(stripCsvFormulaPrefix("")).toBe("");
  });
});