CSV Syntax Definition

100%

CSV Syntax Definition

✓ Published0🌍 Public

Last edited Aug 13, 2012

Created on Aug 13, 2012

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.

AI-generated description

Similar vizzes

Loading thumbnail…

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

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.

CCaged

55% match

Loading thumbnail…

csv2tsv

This example converts comma-separated values to tab-separated values in a single pass. It parses a CSV file from disk using `d3.csv.parse` and immediately formats the resulting data structure as TSV with `d3.tsv.format`. The tool reads its input from a file path provided as a command-line argument and writes the converted output to standard output, enabling easy redirection. The code relies on the `d3` library and Node.js’s `fs` module for file access, and it is intended to be run as an executable script.

Mmbostock

55% match

Loading thumbnail…

Regex to replace commas to points in gedit

This example demonstrates how to use regular expressions in the gedit text editor to replace decimal commas with decimal points in a CSV file. The data, containing numeric values with commas as decimal separators, is shown first, followed by the two-part regex workflow. The find pattern `(\d{1,2}),(\d{1,2})` captures digit groups around a comma, while the replacement string `\1.\2` reconstructs the number with a period. The process relies on gedit’s built-in find-and-replace functionality, which supports regex syntax for pattern matching.

LLuisSevillano

53% match

Loading thumbnail…

CSV

This example demonstrates a bare-bones CSV parsing workflow using D3 v6. It fetches a remote text file containing CSS color data from a GitHub gist, then parses it with `d3.csvParse` to produce a JavaScript array of objects. The parsed data is logged to the browser console, while the container element remains empty, as the code does not yet render any visualization. The page itself is a minimal HTML document that loads D3 from a CDN and relies on the native Fetch API to retrieve the external data source.

KKenGondor

50% match

Loading thumbnail…

parseCSV

This example demonstrates how to parse a semicolon-delimited CSV string and display it as an HTML table. The code embeds a hardcoded dataset with sensor readings, splits it into rows and columns, and dynamically creates table elements. It uses native JavaScript DOM methods like `document.createElement` and `appendChild` to build the table structure, while CSS styles the table with hover effects and alternating row colors. The parsing logic handles the header row separately and converts each data row into a JavaScript object using `Object.defineProperty`.

SStrunck

49% match

Loading thumbnail…

CSV de

This example loads a CSV file of CSS named colors from a GitHub gist and displays basic metadata about it in large text: the file size in kilobytes, the number of rows, and the number of columns. It uses `d3.csv` to fetch and parse the data, then `d3.csvFormat` to compute the size, and writes the summary to a `pre` element. The code also includes an alternative approach using `fetch` with `d3.csvParse`, though it is commented out.

MMayank Kumar

49% match

Loading thumbnail…

Loading and Parsing CSV data

This example demonstrates how to load a remote CSV file and inspect its raw contents in the browser console. It fetches the data from a GitHub gist URL containing CSS color names using the Fetch API’s `fetch` method and `response.text()`, wrapped in an async `fetchText` helper function. The parsed text is logged via `console.log`, revealing the comma-separated values before any formatting or visualization is applied. No external libraries are used; the code relies entirely on native JavaScript promises and async/await syntax.

PPakapone Supavarn

49% match

Loading thumbnail…

Loading and Parsing CSV Data (codeAlong)

This example demonstrates the result of loading and parsing a CSV file of CSS named colors, presenting a text summary of the data's size in kilobytes, row count, and column count within a large-format display. The visualization uses D3 v6’s `d3.csv` method to fetch and parse the remote CSV data, and `d3.csvFormat` to measure the formatted output. It also includes commented-out alternative code using `fetch` and `d3.csvParse`, showing a manual parsing approach.

Ttomahawk-jupiter

49% match