Splunk Search

Remove words from a String

sebafdez
Explorer

Hi guys!

I need to remove words from 2 char in a string, I have a field like:

comment="La pagina web es muy mala demasiado lenta"

and I want it to be like:

new_comment="pagina web muy mala demasiado lenta"

where words of 2 char doesn't exist anymore, any idea how to implement this in SPL?

regards

Tags (1)
0 Karma
1 Solution

woodcock
Esteemed Legend

Like this:

...  | rex field=comment mode=sed "s/ .. / /g s/^.. //g s/ ..$//g"

View solution in original post

0 Karma

somesoni2
Revered Legend

Give this a try (Run anywhere sample search, replace line 1 with your search)

| gentimes start=-1 | eval comment="La pagina web es muy mala demasiado lenta 1 12 123 44" | table comment 
| eval new_comment=replace(comment,"(^|\s)(\w\w)(\s|$)","\1")
0 Karma

woodcock
Esteemed Legend

Like this:

...  | rex field=comment mode=sed "s/ .. / /g s/^.. //g s/ ..$//g"
0 Karma

sebafdez
Explorer

thanks! works great!

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 ...