Skip to main content
100%

Append string on each line to csv file

✓ Published0🌍 Public
Aadkdev
Last edited Sep 24, 2021
Created on Sep 24, 2021

This example demonstrates a shell script that appends the string `"active"` to the end of every line in a CSV file, producing a new output file. It uses the `sed` command with a regular expression to match the end of each line (including lines with or without a trailing carriage return) and replaces it with `,"active"`. The script reads from `file.csv` and writes the modified content to `out.csv`. The transformation relies on POSIX `sed` in extended regex mode, paired with a Bash-specific ANSI-C quoting trick to handle the `\r` character.

AI-generated description

Similar vizzes

Loading thumbnail…

Add , to end of each line

This example shows a simple command-line text-processing workflow that appends a comma to the end of every line in a CSV file. The code uses the Unix stream editor `sed` with the substitution expression `s/$/,/g` to insert a comma at each line’s end, then redirects the output to a new file. It demonstrates a lightweight, scriptable approach for formatting tabular data without a visualization library, relying instead on standard shell tools. The data source is the input CSV file, and the rendering approach is plain text output rather than graphical display.

WWilliamQLiu
68% match
Loading thumbnail…

Remove first line of a csv file with 'sed'

This example demonstrates how to remove the first line of a CSV file using the `sed` command-line utility. The code shows two separate commands: `sed -i '1d' file.csv` deletes the first line, while `sed -i '2d' file.csv` removes the second line. Both commands modify the file in place with the `-i` flag, and the `d` command specifies which line number to delete. The data source is a generic CSV file named `file.csv`.

WWilliamQLiu
59% match
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
52% match
Loading thumbnail…

Sed Cheatsheet

This example is a plain-text cheatsheet listing sed commands for file spacing, numbering, and text conversion or substitution. It shows the exact command-line syntax for each operation, such as `sed G` for double spacing and `sed 's/foo/bar/g'` for global replacement. The source is a gist by AbsarF, and the rendering approach is static text formatting with no interactive or programmatic visualization. It relies solely on shell and sed syntax, not on any JavaScript libraries or data APIs.

AAbsarF
52% match
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
52% 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
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
49% match
Loading thumbnail…

csv concatenation

This example demonstrates the simple concatenation of multiple CSV files into a single output file, combining rows from all input files without any transformation or filtering. The script uses the `csv.reader` and `csv.writer` APIs from Python’s standard library to parse and write each row, while the `glob` module collects every `.csv` filename in a specified directory, and `os.chdir` changes the working directory to that folder. All rows are appended into a flat list, then written to a designated output path. The visualization shows the raw data-merging process, not a graphical chart, and relies solely on file I/O and CSV handling.

IIanHopkinson
49% match