stringify

import { stringify } from "jsr:@ende/csv/unstable-stringify";

function · experimental

function stringify(data: readonly DataItem[], options?: StringifyOptions): string

Converts an array of objects into a CSV string.

data: readonly DataItem[]: The source data to stringify. It's an array of items which are plain objects or arrays.
options?: StringifyOptions: Options for the stringification.

Returns

A CSV string.

Example: Default options

import { stringify } from "@ende/csv/unstable-stringify";
import { assertEquals } from "@ende/assert/equals";

const data = [
  ["Rick", 70],
  ["Morty", 14],
];

assertEquals(stringify(data), `Rick,70\r\nMorty,14\r\n`);

Example: Give an array of objects and specify columns

import { stringify } from "@ende/csv/unstable-stringify";
import { assertEquals } from "@ende/assert/equals";

const data = [
  { name: "Rick", age: 70 },
  { name: "Morty", age: 14 },
];

const columns = ["name", "age"];

assertEquals(stringify(data, { columns }), `name,age\r\nRick,70\r\nMorty,14\r\n`);

Example: Give an array of objects without specifying columns

import { stringify } from "@ende/csv/unstable-stringify";
import { assertEquals } from "@ende/assert/equals";

const data = [
  { name: "Rick", age: 70 },
  { name: "Morty", age: 14 },
];

assertEquals(stringify(data), `name,age\r\nRick,70\r\nMorty,14\r\n`);

Example: Give an array of objects and specify columns with headers: false

import { stringify } from "@ende/csv/unstable-stringify";
import { assertEquals } from "@ende/assert/equals";

const data = [
  { name: "Rick", age: 70 },
  { name: "Morty", age: 14 },
];

const columns = ["name", "age"];

assertEquals(
  stringify(data, { columns, headers: false }),
 `Rick,70\r\nMorty,14\r\n`,
);

Example: Give an array of objects and specify columns with renaming

import { stringify } from "@ende/csv/unstable-stringify";
import { assertEquals } from "@ende/assert/equals";

const data = [
  { name: "Rick", age: 70 },
  { name: "Morty", age: 14 },
];

const columns = [
  { prop: "name", header: "user name" },
  "age",
];

assertEquals(
  stringify(data, { columns }),
 `user name,age\r\nRick,70\r\nMorty,14\r\n`,
);

Example: Give an array of objects with nested property and specify columns

import {
  Column,
  stringify,
} from "@ende/csv/unstable-stringify";
import { assertEquals } from "@ende/assert/equals";

const data = [
  {
    age: 70,
    name: {
      first: "Rick",
      last: "Sanchez",
    },
  },
  {
    age: 14,
    name: {
      first: "Morty",
      last: "Smith",
    },
  },
];

const columns: Column[] = [
  ["name", "first"],
  "age",
];

assertEquals(
  stringify(data, { columns }),
 `first,age\r\nRick,70\r\nMorty,14\r\n`,
);

Example: Give an array of objects with nested property and specify columns

with renaming

import {
  Column,
  stringify,
} from "@ende/csv/unstable-stringify";
import { assertEquals } from "@ende/assert/equals";

const data = [
  {
    age: 70,
    name: {
      first: "Rick",
      last: "Sanchez",
    },
  },
  {
    age: 14,
    name: {
      first: "Morty",
      last: "Smith",
    },
  },
];

const columns: Column[] = [
  { prop: ["name", "first"], header: "first name" },
  "age",
];

assertEquals(
  stringify(data, { columns }),
 `first name,age\r\nRick,70\r\nMorty,14\r\n`,
);

Example: Give an array of string arrays and specify columns with renaming

import { stringify } from "@ende/csv/unstable-stringify";
import { assertEquals } from "@ende/assert/equals";

const data = [
  ["Rick", 70],
  ["Morty", 14],
];

const columns = [
  { prop: 0, header: "name" },
  { prop: 1, header: "age" },
];

assertEquals(
  stringify(data, { columns }),
 `name,age\r\nRick,70\r\nMorty,14\r\n`,
);

Example: Emit TSV (tab-separated values) with separator: "\t"

import { stringify } from "@ende/csv/unstable-stringify";
import { assertEquals } from "@ende/assert/equals";

const data = [
  ["Rick", 70],
  ["Morty", 14],
];

assertEquals(stringify(data, { separator: "\t" }), `Rick\t70\r\nMorty\t14\r\n`);

Example: Prepend a byte-order mark with bom: true

import { stringify } from "@ende/csv/unstable-stringify";
import { assertEquals } from "@ende/assert/equals";

const data = [["Rick", 70]];

assertEquals(stringify(data, { bom: true }), "\ufeffRick,70\r\n");

Source