Skip to content
For the complete documentation index, see llms.txt. This page is also available as Markdown.

replex

Use the replex() function to identify a substring (pattern) and replace it with a new string.

Syntax

replex (<string>, <pattern>, <new_string>)

Parameters

Name
Type
Required
Description

string

string

Yes

The string field or literal value you want to modify.

pattern

string

Yes

The regular expression pattern to find and replace. The pattern must be enclosed in double quotes.

new_string

string

Yes

The string that will replace all occurrences of the matched pattern. This string must also be enclosed in double quotes.

Returns

The replex() function returns a new string with the replacements made. If the pattern is not found, the original string is returned unchanged.

Usage notes

  • The replex() function operates exclusively on string inputs.

  • The function replaces all occurrences of the specified regular expression pattern within the input field.

  • XQL uses the RE2 regular expression implementation.

  • By default, regex patterns are case-sensitive. To achieve case-insensitive matching, the (?i) syntax should be added once at the beginning of the inline regular expression within the pattern string.

  • The replex() function is typically used within the alter stage to create new fields or modify existing ones.

Examples

Example 1: Simple pattern replacement (masking a specific IP address)

Goal: Replace a specific IP address (192.168.1.10) in the raw_log_data field with a placeholder INTERNAL_IP.

XQL code:

Explanation: The query finds the literal IP "192.168.1.10" (escaped dots for regex literal match) in raw_log_data for event_id 101 and replaces it with "INTERNAL_IP", creating the masked_log field.

Output:

EVENT_ID
RAW_LOG_DATA
MASKED_LOG

101

"User Alice logged in from 192.168.1.10"

"User Alice logged in from INTERNAL_IP"

Example 2: Using regex character classes for general IP address masking

Goal: Use a regular expression to find and mask any standard IPv4 address pattern in the raw_log_data or ipv4_address fields.

XQL code:

Explanation: The query uses the regex \d{1,3}\.\d{1,3}\.\d{1,3}\.\d{1,3} to identify and replace dotted-decimal IPv4 addresses. For event 101, ipv4_address is masked. For event 103, the IP in raw_log_data is masked.

Output:

EVENT_ID
IPV4_ADDRESS
MASKED_IPV4
RAW_LOG_DATA
MASKED_RAW_LOG

101

"192.168.1.10"

"MASKED_ADDR"

"User Alice logged in from 192.168.1.10"

"User Alice logged in from MASKED_IP"

103

NULL

NULL

"Outbound connection to 1.1.1.1:443 initiated by AppX"

"Outbound connection to MASKED_IP:443 initiated by AppX"

Example 3: Replacing multiple occurrences of a word

Goal: Target raw_log_data and replace multiple instances of whitespace characters with "_".

XQL code:

Explanation: The replex() function finds all instances of the whitespace character " " and replaces them with "_".

Output:

EVENT_ID
RAW_LOG_DATA
UPDATED_LOG

103

"Outbound connection to 1.1.1.1:443 initiated by AppX"

"Outbound_connection_to_1.1.1.1:443_initiated_by_AppX"

Example 4: Case-insensitive replacement using (?i)

Goal: Perform a case-insensitive replacement by using the (?i) flag to match "User" or "user" regardless of capitalization, replacing it with "ACCOUNT_HOLDER" in event_description.

XQL code:

Explanation: By prefixing the regex with (?i), replex() ignores case, successfully replacing "User" (with a capital 'U') in event_description with "ACCOUNT_HOLDER".

Output:

EVENT_ID
EVENT_DESCRIPTION
ANONYMIZED_DESC

101

"User login successful"

"ACCOUNT_HOLDER login successful"

Example 5: Removing a pattern (replacing with an empty string)

Goal: Remove the " from " followed by an IP address from raw_log_data by replacing the pattern with an empty string.

XQL code:

Explanation: The regex matches " from " followed by any IPv4 pattern. replex() then replaces this entire matched substring with an empty string, effectively removing it and cleaning the raw_log_data entry.

Output:

EVENT_ID
RAW_LOG_DATA
CLEANED_LOG

101

"User Alice logged in from 192.168.1.10"

"User Alice logged in"

Last updated

Was this helpful?