Common Transformations

Learn how to leverage essential SQL transformations in Coalesce for data manipulation. This comprehensive guide covers common string and data manipulation functions with detailed syntax, examples, and best practices for integrating these transformations into your data pipelines.

📄️ REPLACE

Learn how to the REPLACE function in Coalesce to standardize data formats, remove unwanted prefixes, and clean text fields.

📄️ SUBSTR

Learn how to use the SUBSTR function in Coalesce to extract substrings from text data. This guide covers position-based string extraction, both positive and negative indexing, optional length parameters, and practical examples using Helper Tokens.

📄️ TRIM Functions

Coalesce's comprehensive guide to LTRIM, RTRIM, and TRIM for cleaning string data, with syntax, examples, and best practices.

📄️ Using Math in Transformations

Learn how to use basic mathematical operations in SQL transformations to calculate derived values from numeric columns.