Splunk Search

Remove non alphanumeric in the datamodel

robertlynch2020
Influencer

Hi

I have datamodel data like below.
I have tried to remove all non alphanumeric. So i can put it on a new field in a datamodel "Add Fields with a Regular Expression" in the datamodel, but i just cant seem to crack it.
I think i need to use a function of some sort as perhaps it is not easy done in REGEX.

I would like to keep the underscores, or replace all the new characters with an underscore is also fine.

^(?P<source_path>/[^0-9!&',-.\\/a-z\n]/)

What i have
peter hi
ex&it
field=1;like&
name
john

What i want
peterhi
exit
field1like
name
john

alt text
Cheers in advance

0 Karma

mhoogcarspel_sp
Splunk Employee
Splunk Employee

Maybe try an eval based field with replace()

I checked it using:
| makeresults | head 1| eval _raw="field = 1;like&" | eval testfield=replace(_raw, "[^0-9&',-.\\/a-z\n]", "")

testfield comes out as: "field1like&"

0 Karma
Get Updates on the Splunk Community!

Upcoming Webinar: Unmasking Insider Threats with Slunk Enterprise Security’s UEBA

Join us on Wed, Dec 10. at 10AM PST / 1PM EST for a live webinar and demo with Splunk experts! Discover how ...

.conf25 technical session recap of Observability for Gen AI: Monitoring LLM ...

If you’re unfamiliar, .conf is Splunk’s premier event where the Splunk community, customers, partners, and ...

A Season of Skills: New Splunk Courses to Light Up Your Learning Journey

There’s something special about this time of year—maybe it’s the glow of the holidays, maybe it’s the ...