qie.escapeCsv

Signature: qie.escapeCsv(value)

Returns: String escapedValue - the escaped value

Escape the value to be used in a CSV file.

Parameters

Type	Name	Description	Default
String	value	the value to be escaped

Example

// Create a CSV table with headers only
var csv = qie.parseCSVString("Name,favorite color,quote", false, '"', ',', true, 'utf-8');
var singleCsvFieldName = 'James ("Dean") Brown';
var secondCsvFieldName = 'Michael Wiley';
var singleCsvFieldColor = 'Brown';
var secondCsvFieldColor = 'Bleu';
var singleCsvFieldQuote = 'The quick brown fox jumped over the lazy dog.';
var secondCsvFieldQuote = 'I, me, we\nWill conquer!';

// escapeCsv will quote and escape values containing commas, quotes, or newlines
csv.setNode('Name[1]', qie.escapeCsv(singleCsvFieldName));
csv.setNode('favorite color[1]', qie.escapeCsv(singleCsvFieldColor));
csv.setNode('quote[1]', qie.escapeCsv(singleCsvFieldQuote));

csv.setNode('Name[2]', qie.escapeCsv(secondCsvFieldName));
csv.setNode('favorite color[2]', qie.escapeCsv(secondCsvFieldColor));
csv.setNode('quote[2]', qie.escapeCsv(secondCsvFieldQuote));