Getting Data In

Is it possible to do search time field extraction based punct

fredclown
Builder

I have events in a log file and they have different formats from event to event. I'm wondering if there is any way to use the punct field to do conditional field extraction? Let's say I have these two punct formats ...

___::_---..__//:::__---_--_:______:____-___-__..._

___::_---..__//:::__---_--_:______:___...:_-__...:

 

Edit:

I'm specifically asking about doing it with props and transforms so that the fields are reusable.

Labels (1)
0 Karma

isoutamo
SplunkTrust
SplunkTrust

I think that you cannot do this with props and transforms. The reason for that is the order how those different processors are done in ingestion phase. See e.g https://www.aplura.com/assets/pdf/props_conf_order.pdf

Based on that diagram, ANNOTATE_PUNCT is after Splunk has apply other props and transforms stuff and events cannot go backwards on ingestion pipeline.

0 Karma

PrewinThomas
Motivator

@fredclown 

Yes. You can use it for conditional field extraction.

eg:

| makeresults count=2
| streamstats count as row
| eval _raw=case(
row=1, "abc::123-45..xy//:::zz-88-99:demo...end",
row=2, "abc:123-45..xy//:::zz-88-99:demo:from...:demo...:"
)
| eval punct=replace(_raw, "[A-Za-z0-9]", "_")
| eval type=case(
match(punct, "\\.\\.\\.___$"), "Type A",
match(punct, "\\.\\.\\.:$"), "Type B",
true(), "Unknown"
)
| table row _raw punct type

demo.JPG

Regards,
Prewin
Splunk Enthusiast | Always happy to help! If this answer helped you, please consider marking it as the solution or giving a Karma. Thanks!

0 Karma

fredclown
Builder

Thanks, and sorry I was not clear enough. I want to do this with props and transforms so that the fields are reusable.

0 Karma

PickleRick
SplunkTrust
SplunkTrust

punct is (if it's generated, because its creation can be disabled) an indexed field like any other so you can use it. But the question is what do you mean by "conditional" extraction.

0 Karma
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Kick the Tires Before You Commit: A Hands-On Tour of the Splunk Observability Cloud ...

Evaluating an enterprise observability platform usually goes like this: fill out a form, get a free trial with ...

Deep insights, no barriers: Splunk Observability Cloud Free Edition

As software delivery cycles continue to accelerate, observability shouldn’t be a luxury — it should be a ...

Monitoring AI Agents with Splunk Observability Cloud

Let’s say I’m running a travel planning AI app in production. A user asks for three concise hotel options in ...