Data8 Expression Library
This guide explains the expressions available within Data8 Duplicare. It is written for users with little or no SQL knowledge, using clear, simple language. Each function name remains exactly as used in the platform, while descriptions focus on real‑world usefulness rather than technical detail.
These functions can be used across merge+ rules, in both fields and the master select order.
String Functions
| Function | Description |
|---|---|
| ConvertToString(value) | Converts any value into text. |
| AppendIfNotNullOrEmpty(prefix, suffix) | Adds suffix only if prefix has content. |
| HtmlEncode(s) | Encodes text for HTML. |
| UrlEncode(s) | Encodes text for URLs. |
| Base64Encode(s) | Converts text to Base64. |
| Char(code) | Returns character from code. |
| Replace(target, find, replace) | Replaces occurrences of text. |
| MaxLength(s, length) | Trims text to maximum length. |
| PadLeft(s, length, padding) | Adds characters on the left. |
| PadRight(s, length, padding) | Adds characters on the right. |
| Length(s) | Counts characters. |
| Substring(s, start, length) | Extracts text starting at position. |
| IndexOf(s, value) | Finds position of text. |
| TrimStart(s) | Removes leading spaces. |
| TrimStart(s, chars) | Removes specified chars from start. |
| TrimEnd(s) | Removes trailing spaces. |
| TrimEnd(s, chars) | Removes specified chars from end. |
| Trim(s) | Removes spaces both sides. |
| Trim(s, chars) | Removes specified chars both sides. |
| RegexMatch(input, pattern) | Tests text against a regex. |
| RegexGroup(input, pattern, groupName) | Extracts named regex group. |
| RegexReplace(input, pattern, replacement) | Replaces text using regex. |
| ParseGuid(input) | Converts to GUID. |
| UpperCase(s) | Uppercase text. |
| LowerCase(s) | Lowercase text. |
| Left(s, length) | Takes left part of text. |
| Right(s, length) | Takes right part of text. |
Numeric Functions
| Function | Description |
|---|---|
| Round(value) | Rounds to whole number. |
| RoundDP(value, dp) | Rounds to decimal places. |
| ParseInt32(value) | Converts a string to 32-bit integer. |
| ConvertToInt32(value) | Converts an object to 32-bit integer. |
| ParseInt64(value) | Converts a string to 64-bit integer. |
| ConvertToInt64(value) | Converts an object to 64-bit integer. |
| ParseDouble(value) | Converts a string to decimal. |
| ConvertToDouble(value) | Converts an object to decimal. |
| Log(value, b) | Logarithm. |
Date/Time Functions
| Function | Description |
|---|---|
| ParseDateTime(s) | Converts text to DateTime. |
| ParseDateTimeExact(s, format) | Exact format DateTime parse. |
| MinDateTime() | Earliest date. |
| MaxDateTime() | Latest date. |
| Now() | Current date/time. |
| Today() | Today's date. |
| AddYears(dt, years) | Adds/subtracts years. |
| AddMonths(dt, months) | Adds/subtracts months. |
| AddDays(dt, days) | Adds/subtracts days. |
| AddHours(dt, hours) | Adds/subtracts hours. |
| AddMinutes(dt, minutes) | Adds/subtracts minutes. |
| AddSeconds(dt, seconds) | Adds/subtracts seconds. |
| ToUnixTimestamp(dt) | Date to Unix timestamp. |
| Year(dt) | Extracts year. |
| Month(dt) | Extracts month. |
| Day(dt) | Extracts day. |