replace
Description
Replaces field values in your search results with the values that you specify. Does not replace values in fields generated by stats
or eval
functions. If you do not specify a field, the value is replaced in all non-generated fields.
Syntax
replace (<wc-string> WITH <wc-string>)... [IN <field-list>]
Required arguments
- wc-string
- Syntax: <string>
- Description: Specify one or more field values and their replacements. You can use wildcard characters to match one or multiple terms.
Optional arguments
- field-list
- Syntax: <string> ...
- Description: Specify a comma or space delimited list of one or more field names for the field value replacements. To replace values on
_internal
fields, you must specify the field name with the IN <fieldname> clause.
Usage
The replace
command is a distributable streaming command. See Command types.
Non-wildcard replacement values specified later take precedence over those replacements specified earlier. For a wildcard replacement, fuller matches take precedence over lesser matches. To assure precedence relationships, you are advised to split the replace into two separate invocations. When using wildcard replacements, the result must have the same number of wildcards, or none at all. Wildcards ( * ) can be used to specify many values to replace, or replace values with.
Examples
1. Replace a value in all fields
Change any host value that ends with "localhost" to simply "localhost" in all fields.
... | replace *localhost WITH localhost
2. Replace a value in a specific field
Replace an IP address with a more descriptive name in the host
field.
... | replace 127.0.0.1 WITH localhost IN host
3. Change the value of two fields
Replaces the values in the start_month
and end_month
fields. You can separate the names in the field list with spaces or commas.
... | replace aug WITH August IN start_month end_month
4. Change the order of values in a field
In the host field, change the order of string values that contain the word localhost
so that the string "localhost" precedes the other strings.
... | replace "* localhost" WITH "localhost *" IN host
5. Replace multiple values in a field
Replace the values in a field with more descriptive names. Separate the value replacements with comma.
... | replace 0 WITH Critical, 1 WITH Error IN msg_level
6. Replace empty strings
Search for an error message and replace empty strings with a whitespace.
This example will not work unless you have values that are actually the empty string, which is not the same as not having a value.
"Error exporting to XYZ :" | rex "Error exporting to XYZ:(?.*)" | replace
"" WITH " " IN errmsg
7: Replace values in an internal field
Replace values of the internal field _time
.
sourcetype=* | head 5 | eval _time="XYZ" | stats count BY _time | replace *XYZ* WITH *ALL* IN _time
See also
- Commands
- rename
rename | require |
This documentation applies to the following versions of Splunk Cloud Platform™: 8.2.2112, 8.2.2201, 8.2.2202, 8.2.2203, 9.0.2205, 9.0.2208, 9.0.2209, 9.0.2303, 9.0.2305, 9.1.2308, 9.1.2312, 9.2.2403 (latest FedRAMP release), 9.2.2406
Feedback submitted, thanks!