simple parse csv via Deno 🦕

parseCsv.ts

import { parse as parseCsv } from 'https://deno.land/std@0.82.0/encoding/csv.ts'

const data = await parseCsv(await Deno.readTextFile('data.csv'))
const query = await parseCsv(await Deno.readTextFile('query.csv'))

if (import.meta.main) {
	const Q = query.flatMap((row) => row)

	const INDEX = {
		name: 1,
		owner_id: 3,
	}

	const result = data.filter((row: any) => Q.includes(row[INDEX.owner_id]))
	const formatted = result
		.map((row: any) => [
			row[INDEX.owner_id],
			'https://' + row[INDEX.name] + '.example.com',
		])
		.map((row) => `${row[0]};${row[1]}`)
		.join('\n')

	await Deno.writeTextFile('./result.csv', formatted)
}