simstudioai--sim/apps/sim/lib/table/export-format.ts

/**
 * Shared serialization for table exports — used by both the synchronous streaming export route
 * (small tables) and the background export job worker (large tables), so the two paths produce
 * byte-identical files.
 */

import { columnTypeOf } from '@/lib/table/column-types'
import { selectValueToNames } from '@/lib/table/select-values'
import type { ColumnDefinition } from '@/lib/table/types'

/**
 * @deprecated Use `selectValueToNames` from `@/lib/table/select-values`. Kept as
 * an alias so existing export callers/tests don't churn.
 */
export const resolveSelectExportValue = selectValueToNames

export function sanitizeExportFilename(name: string): string {
  const cleaned = name.replace(/[^a-zA-Z0-9_-]+/g, '_').replace(/^_+|_+$/g, '')
  return cleaned || 'table'
}

/**
 * Prefixes a single quote to values starting with a spreadsheet formula trigger
 * (`=`, `+`, `-`, `@`, tab, CR), neutralizing CSV injection in Excel/Sheets.
 */
export function neutralizeCsvFormula(value: string): string {
  return /^[=+\-@\t\r]/.test(value) ? `'${value}` : value
}

/**
 * Serializes a cell for CSV. Only string cells are formula-neutralized; numbers,
 * booleans, dates, and JSON objects can never form a trigger and pass through verbatim.
 */
export function formatCsvValue(value: unknown): string {
  if (value === null || value === undefined) return ''
  if (value instanceof Date) return value.toISOString()
  if (typeof value === 'object') return JSON.stringify(value)
  if (typeof value === 'string') return neutralizeCsvFormula(value)
  return String(value)
}

/**
 * Serializes one cell for CSV, resolving `select` option ids to their names
 * (comma-joined for multi) so the file shows the enum label, not the id.
 */
export function formatCsvCell(column: ColumnDefinition, value: unknown): string {
  // Every other type writes its stored value verbatim so the file re-imports
  // byte-identically.
  if (columnTypeOf(column).storesOpaqueIds) {
    return neutralizeCsvFormula(columnTypeOf(column).formatForDisplay(value, column))
  }
  return formatCsvValue(value)
}

export function toCsvRow(values: string[]): string {
  return values.map(escapeCsvField).join(',')
}

function escapeCsvField(field: string): string {
  if (/[",\n\r]/.test(field)) {
    return `"${field.replace(/"/g, '""')}"`
  }
  return field
}