Sofiya Tepikin
35 lines
903 B
JavaScript
35 lines
903 B
JavaScript
import objectPath from 'object-path'
|
|
import getColumnNamesForCsv from './get-csv-column-names'
|
|
|
|
|
|
export default function transformToCsv(cycleDays) {
|
|
const columnNames = getColumnNamesForCsv()
|
|
const rows = cycleDays
|
|
.map(day => {
|
|
return columnNames.map(column => {
|
|
const val = objectPath.get(day, column)
|
|
return typeof val === 'string' ? csvify(val) : val
|
|
})
|
|
})
|
|
.map(row => row.join(','))
|
|
rows.unshift(columnNames.join(','))
|
|
return rows.join('\n')
|
|
}
|
|
|
|
function csvify (val) {
|
|
// we wrap fields with special characters in quotes,
|
|
// thus have to escape actual quotes
|
|
val = val.replace(/"/g, '""')
|
|
|
|
val = val.toLowerCase()
|
|
const hasSpecialChars = (
|
|
val.includes('\n') ||
|
|
val.includes('\t') ||
|
|
val.includes(',') ||
|
|
val.includes(';') ||
|
|
val.includes('.') ||
|
|
val.includes('\'')
|
|
)
|
|
|
|
return hasSpecialChars ? `"${val}"` : val
|
|
} |