Splunk Search

replace string in field value using eval or sed

Sri401
New Member

I have one field(query) value like

select * from host where id = 'something' and name = 'xxxxxx'

Now I want to replace id and name with '?'

I have tried with rex and sed something like
rex field=query mode=sed "s/name*./?/g" and also using eval filed=replace....

but i didn't find the solution

can any one please help me with this

0 Karma

richgalloway
SplunkTrust
SplunkTrust

The regex is incorrect. It's looking for "nam" followed by any number of "e"s followed by any character. Try this:

| rex field=query mode=sed "s/name/?/g" | rex field=query mode=sed "s/id/?/g"
---
If this reply helps you, Karma would be appreciated.
0 Karma

Sri401
New Member

thanks for your response,

I want to replace name and id value with ?. after replace string the output looks like

select * from host where id = '?' and name = '?'

name and id values are dynamic

0 Karma

richgalloway
SplunkTrust
SplunkTrust

That's different, but similar.

| rex field=query mode=sed "s/(name\s*=\s*')[^']+/\1/g" | rex field=query mode=sed "s/(id\s*=\s*')[^']+/\1/g"
---
If this reply helps you, Karma would be appreciated.
0 Karma
Get Updates on the Splunk Community!

Dashboards: Hiding charts while search is being executed and other uses for tokens

There are a couple of features of SimpleXML / Classic dashboards that can be used to enhance the user ...

Splunk Observability Cloud's AI Assistant in Action Series: Explaining Metrics and ...

This is the fourth post in the Splunk Observability Cloud’s AI Assistant in Action series that digs into how ...

Brains, Bytes, and Boston: Learn from the Best at .conf25

When you think of Boston, you might picture colonial charm, world-class universities, or even the crack of a ...