Regex to replace commas to points in gedit

100%

Regex to replace commas to points in gedit

✓ Published0🌍 Public

Last edited Oct 30, 2019

Created on Oct 25, 2019

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.

AI-generated description

Similar vizzes

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

53% 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

48% match

Loading thumbnail…

Gist e75fdfd9429caf37873275cd41779b88

This example demonstrates a custom formatting function that inserts non-breaking spaces as thousands separators, a convention common in Finnish numeric formatting. The function, `spaceSeparateNumber`, iteratively processes the input number using a regular expression to identify digit groups, replacing them with a space between the leading digits and the trailing three-digit group. It relies on JavaScript’s string replacement and number-to-string conversion, without any external libraries. The visualization likely applies this formatting to numeric labels in a chart, ensuring readable, localized display of large values. The code focuses solely on text transformation, not on rendering or data binding, making it a standalone utility for formatting axis ticks or tooltip values.

EEelsie

48% match

Loading thumbnail…

Currency Pattern for text input (US)

This example demonstrates a US currency input field that uses an HTML pattern attribute to validate dollar amounts. It shows how a regular expression restricts user input to acceptable formats, including an optional dollar sign, commas for thousands separators, and up to two decimal places. The code defines a single `<input>` element of type `text` with an ID of `dollarAmount`, applying the `pattern` attribute for validation and a `title` attribute to provide a custom error message. No JavaScript libraries or frameworks are used; the rendering relies entirely on native HTML5 form validation behavior.

LLucyI

47% match

Loading thumbnail…

Power Query regex example from http://www.thebiccountant.com/2018/04/25/regex-in-power-bi-and-power-query-in-excel-with-java-script/

This example demonstrates how to extract numeric patterns from a mixed-language string using regular expressions within Power Query. It defines a custom function that invokes JavaScript’s `RegExp` and `String.match` via the `Web.Page` HTML/JavaScript execution environment, passing a target string and a regex pattern. The specific call extracts all digit sequences from “hello012中国1235” and returns them as a list. This approach highlights Power Query’s ability to leverage external scripting for text processing, bridging M’s native functions with JavaScript’s regex engine for advanced pattern matching.

HHugoberry

47% match

Loading thumbnail…

C# number to comma separated string

This example demonstrates converting a numeric value into a comma-separated string for display. It shows how a double precision number, 2000.4, is formatted with both thousands separators and a configurable number of decimal places. The code calls the `ToString` method on the double with the custom format string `"#,##0.##"`, which inserts commas between thousands groups and limits decimals to two digits without trailing zeros. The rendering approach is a simple console-style output, using the .NET `double` type and its built-in formatting API.

IIliaIdakiev

46% match

Loading thumbnail…

Eloquent JS: Chapter 9

This example demonstrates regular expression patterns from Chapter 9 of Eloquent JavaScript, testing and replacing text in a console. It uses JavaScript’s native `RegExp` methods like `test`, `exec`, and `replace` to match patterns such as car/cat, quoted phrases, and INI configuration parsing. The visualization renders results in an SVG-based React interface using D3 v5, displaying matched strings and substitution outputs as static text elements within the 960×500 canvas.

Eemberix@gmail.com

46% 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

45% match