Text manipulation
The process of altering, parsing, or transforming character strings to facilitate Data Cleaning, data-extraction, and data-formatting.
Core Techniques
- regular-expressions (Regex): Utilizing pattern-matching syntax to identify, isolate, or modify complex string sequences.
- String Parsing: Deconstructing text into constituent, identifiable components.
- Pattern Substitution: Replacing identified substrings with new values based on defined criteria.
Tools & Applications
Microsoft Excel
- Native integration of regular-expressions via new specialized functions:
REGEXEXTRACT: Streamlines data-extraction by pulling specific patterns from unstructured cells.REGEXREPLACE: Enables efficient Data Cleaning and pattern-based text replacement/formatting.
- Reference: 2026 04 22 Excels REGEX Functions Efficient Data Extraction Cleaning and Formatting
Source Notes
- 2026-04-07: Nano Banana 2 JSON Control for Precise AI Image Editing in Gemini · ▶ source
- 2026-04-27: Correcting AI Infographic · ▶ source