Replace nested double quotes with single quotes in these CSV strings.

100%

Replace nested double quotes with single quotes in these CSV strings.

✓ Published0🌍 Public

Last edited Sep 13, 2011

Created on Sep 13, 2011

This example demonstrates a text-processing routine that cleans malformed CSV data by replacing nested double quotes with single quotes. It operates on two hardcoded strings containing street names and player nicknames with embedded quoted terms, such as `"Dearil "DJ""` and `"Calvert "C.J.""`. The code uses Ruby string interpolation with `%()` literals to define the input strings, then applies a regular expression to substitute the inner quote pairs. The output is not visualized but rendered as plain corrected CSV lines, showing how the transformation standardizes quote usage for downstream parsing.

AI-generated description

Similar vizzes

Loading thumbnail…

Gist fdfdd728007f46922fdc

This example demonstrates how to read and write text and CSV files in Ruby, using the CSV library. It reads names from a text file into an array, prints the array, and then appends the word "likes" to each name before saving the result to another text file. The code also writes the original names to a CSV file. This is a file-processing utility rather than a data visualization, focusing on data manipulation and storage.

AAndrelton

56% match

Loading thumbnail…

CSV Syntax Definition

This example defines a TextMate grammar for syntax highlighting Comma-Separated Values (CSV) files. It specifies patterns to recognize quoted strings, escaped double quotes, and comma separators, assigning distinct scope names like `string.quoted.csv` and `keyword.operator.comma.csv`. The grammar is written in the plist-based `CSV.tmLanguage` format, intended for use with editors and highlighters that support TextMate language definitions. The rules show how to match field boundaries while preserving escaped characters within quoted sections.

Mmbostock

55% match

Loading thumbnail…

Gist 585199

This visualization loads an external CSV file and parses its rows into JavaScript objects, mapping each column name from an array to the corresponding values in each line. It handles quoted fields that contain commas by merging split segments until the quote count is even, and it logs warnings for malformed lines that do not match the expected number of columns. The example demonstrates a reusable CSV-asynchronous-loading helper, but does not show any charting, layout, or rendering code beyond the data preparation stage.

RRandomEtc

54% match

Loading thumbnail…

Using tr

This example demonstrates how to convert CSV files with non-Unix line endings into Unix format using the command-line utility `tr`. It shows two conversion scenarios: replacing carriage returns (`\r`) with line feeds (`\n`) for files with Mac OS 9 endings, and deleting carriage returns to handle Windows-style `\r\n` endings. The code processes the DC Metrorail ridership dataset, which contains daily totals, and verifies the results by comparing output files with `md5sum`. Alternative tools like `mac2unix` and `dos2unix` are also presented for the same task.

LLeeMendelowitz

53% match

Loading thumbnail…

CsvFieldsSaver + Tests

This example demonstrates a C# class, CsvFieldsSaver, that formats form data into CSV output through a TextWriter, handling edge cases like commas, double quotes, leading/trailing spaces, and embedded line breaks by enclosing values per CSV standards. It uses NUnit for testing and Rhino Mocks to mock writers, with a FileWriter wrapping a StreamWriter around a MemoryStream to verify the resulting CSV strings. The code shows how to quote embedded double quotes by doubling them, and focuses on unit-testing the serialization logic.

RRestuta

53% match

Loading thumbnail…

Parse CSV with Day of DH Quotations as XML

This example shows how to randomly select and display a single quotation from a CSV file of "Day of DH" responses, rendering it as a styled HTML page. It first parses the remote CSV with the `csv:parse` function and `fetch:text`, then uses `random:integer` to pick a random record. The code generates a Bootstrap-based webpage that displays the quote, author, and date. The XQuery scripts include a plain parsing version, a random-selection version, and two HTML-rendering versions, one using the RESTXQ module for HTTP GET requests.

CCliffordAnderson

53% match

Loading thumbnail…

Convert raw NBA JSON to CSV.

This example converts raw NBA JSON game logs into a single CSV file, first showing the transformation of nested statistics into flat, queryable rows. It reads JSON files for each season and measure type, extracting headers and parameters to build team-level records with prefixed column names like `pace_*` or `def_rating_*`. The script uses the CoffeeScript language and the Node.js `fs` and `csv` libraries, with the `csv().to.path` API to write the output. It also merges team abbreviations from a separate CSV, keying each row by team ID and season.

CCaged

51% match

Loading thumbnail…

Quick node.js script to convert a CSV file to HTML

A quick Node.js script converts CSV spreadsheet data into standalone HTML pages by applying a template to each row. It uses the `csv` library to parse an input file with named columns and the `ejs` templating engine, configured with curly braces, to interpolate row values into the output. The script validates file extensions (`.csv`, `.ejs`, `.html`) and writes the rendered templates to a single output file, joining them with platform-appropriate line endings. The example includes a template that displays each item’s title, link, source, and year as formatted HTML.

RRandomEtc

50% match