csv.ts

packages/sheets-client/src/csv.ts

1. /**
2. * RFC 4180 CSV, because the tracker's cells contain the things a naive split
3. * breaks on: commas inside task titles, newlines inside notes, and quotes
4. * inside both.
5. *
6. * A row shaped like the ones in the sheet:
7. *
8. * "Refresh the vinyl banner gallery images
9. * Recrop the hero image (subject too close to the edge...)"
10. *
11. * That is one cell containing a newline. Splitting on '\n' first turns it into
12. * two rows, the second of which has no owner, so it lands in "unowned work"
13. * and someone goes looking for who dropped it. Parse properly or not at all.
14. */
15. export function parseCsv(text: string): string[][] {
16. const rows: string[][] = []
17. let row: string[] = []
18. let cell = ''
19. let quoted = false
21. // Strip a BOM: Google does not send one today, but a hand-saved re-export
22. // will, and it would silently corrupt the first header name.
23. const s = text.charCodeAt(0) === 0xfeff ? text.slice(1) : text
25. for (let i = 0; i < s.length; i++) {
26. const c = s[i]!
27. if (quoted) {
28. if (c === '"') {
29. if (s[i + 1] === '"') {
30. cell += '"'
31. i++
32. } else {
33. quoted = false
34. }
35. } else {
36. cell += c
37. }
38. continue
39. }
40. if (c === '"') {
41. quoted = true
42. } else if (c === ',') {
43. row.push(cell)
44. cell = ''
45. } else if (c === '\n' || c === '\r') {
46. // Swallow CRLF as one break rather than emitting a phantom empty row.
47. if (c === '\r' && s[i + 1] === '\n') i++
48. row.push(cell)
49. rows.push(row)
50. row = []
51. cell = ''
52. } else {
53. cell += c
54. }
55. }
56. // A file that does not end in a newline still has a last row.
57. if (cell !== '' || row.length) {
58. row.push(cell)
59. rows.push(row)
60. }
61. return rows
62. }