Extract the first character of each string part separated by the '-'. There can be an unknown number of potential parts.

100%

Extract the first character of each string part separated by the '-'. There can be an unknown number of potential parts.

✓ Published0🌍 Public

Last edited Dec 26, 2015

Created on Dec 26, 2015

This example demonstrates how to extract the first character of each string segment separated by hyphens, regardless of the number of segments, and concatenate them into a single output. It shows a concise SQL pattern for parsing structured text data. The query uses PostgreSQL’s `regexp_matches` function with a global flag to find all alphanumeric characters, then aggregates the results with `array_agg` and converts the array to a string via `array_to_string`. The source data, ‘Letter-1-2’, is processed to yield the abbreviated result, highlighting the reusable regex and array functions for dynamic text parsing.

AI-generated description

Similar vizzes

Loading thumbnail…

Gist 6ca203fa1eab16a0f3c98d442ba9eea0

This example demonstrates a JavaScript function that transforms an input string into a "mumbling" pattern, where each character is repeated incrementally, capitalized at the start, and joined by hyphens. The visualization shows the result of applying this logic to sample strings like "abcd," "cwAt," and "RqaEzty" using the built-in `split`, `toLowerCase`, `toUpperCase`, `slice`, `map`, and `join` methods, along with custom `capitalize` and `accum` functions. The code relies on plain JavaScript string array manipulation without external libraries, producing outputs such as "A-Bb-Ccc-Dddd" for the first example.

MMistyBlunch

47% match

Loading thumbnail…

Gist 1f915686384da18e413f6fc5f50abfc7

This example visualizes a data-transformation utility that removes dashes from string arrays. It demonstrates a reusable JavaScript function called `removeDashesFrom`, which iterates through an input array and strips every hyphen character from each element using the `replace` method. The code logs its execution to the console, indicating a step-by-step processing flow. While no specific visualization library is used, the example highlights a common data-cleaning operation, likely intended for preprocessing datasets before feeding them into a charting framework like D3.js or Three.js. The function returns the modified array, making it suitable for integration into larger data-visualization pipelines where clean string formatting is required.

WWill Carter

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

45% match

Loading thumbnail…

Gist 75454

This example demonstrates string manipulation utilities in Objective-C, converting camelCase or mixed-case strings into either underscore-separated or dash-separated formats. The code defines an NSString category with `underscore` and `dasherize` methods, which internally call a private `normalizeWith:` method that iterates over each character, detects uppercase letters and existing delimiters, and inserts the chosen separator while preserving the original text. The implementation uses NSCharacterSet, NSMutableString, and unichar APIs to perform character-by-character processing, ultimately returning a lowercase version of the transformed string.

CCaged

44% match

Loading thumbnail…

R Regex matching of mentions in twitts. with Power Query and R

This example demonstrates how to extract regex-matched mentions (prefixed with `#` or `@`) from Twitter text using R within a Power Query workflow. The visualization shows the original tweets alongside a new `mention` column containing the first matched term. The solution uses the `R.Execute` function to run an R script that applies `regmatches` and `regexpr` with the pattern `[#@]\w+` across the `text` column. The R script processes the dataset provided by Power Query, leveraging R's base string manipulation functions. The data originates from a CSV file loaded via `Csv.Document`, with the final result passed back to Power Query through the `[Name="temp"]` output.

HHugoberry

43% match

Loading thumbnail…

Remove first prefix from filename

This example demonstrates a shell script that renames files by stripping the first prefix from each filename, up to and including the first period. It shows a concise file-management task rather than a data visualization. The code iterates over all files in the current directory using a `for` loop and applies the `mv` command with parameter expansion (`${file#*.}`) to remove the shortest prefix ending in a period. No external libraries or rendering APIs are involved; the logic relies solely on standard Unix shell constructs and the `mv` utility. The data source is the filesystem, and the output is the renamed files.

HHypercubed

43% match

Loading thumbnail…

writing the numbers 1-100 in order and seeing the middle letter

This example examines the letters at the center of the concatenated text formed by writing the numbers 1 through 100 as words, with and without hyphens. It uses Python’s built-in string methods to join the number list, remove hyphens, and index the middle character by calculating half the total length. The visualization shows the resulting middle letter for four variations: with and without hyphen removal, and with spaces versus no spaces between numbers. The code relies solely on Python’s `list`, `join`, `replace`, and `len` functions, with no external libraries or graphical output.

BBBischof

42% match

Loading thumbnail…

Quick alphabetic sorting of Vanderbilt email addresses

This example demonstrates a straightforward method for alphabetically sorting a list of Vanderbilt email addresses extracted from a Markdown file. The code loads the email addresses using `fn:unparsed-text-lines`, then performs a case-sensitive sort based on a specific portion of the address. It applies a regular expression via `fn:replace` to isolate the username segment after the first period, and orders the results with an `order by` clause in XQuery 3.1. The output is the sorted list of emails, showing the sorting logic directly in the query.

CCliffordAnderson

42% match