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!

See just what you’ve been missing | Observability tracks at Splunk University

Looking to sharpen your observability skills so you can better understand how to collect and analyze data from ...

Weezer at .conf25? Say it ain’t so!

Hello Splunkers, The countdown to .conf25 is on-and we've just turned up the volume! We're thrilled to ...

How SC4S Makes Suricata Logs Ingestion Simple

Network security monitoring has become increasingly critical for organizations of all sizes. Splunk has ...