Splunk Search

Is there any way of searching for any character follow by comma using rex

rajivchadha
New Member

Does splunk rex have a concept of doing a .*, in the rex function? I basically want to search for any character followed by a comma.

Tags (2)
0 Karma
1 Solution

javiergn
Super Champion

Does "any character" include commas too?

If not, you can possibly do it like this:

"[^\,]+\,"

Which reads as 1 or more non-comma characters followed by a comma.

You can then group all of that in a token you want to capture, and problem solved.

| rex "(?<fieldnameFoo>[^\,]+)\,"

Thanks,
J

View solution in original post

0 Karma

jkat54
SplunkTrust
SplunkTrust

In regex . stands for any character and \, stands for comma.

So

  | rex (?<anyChar>.)\, 

Should work

However if you're not wanting to extract the field and instead you're just searching for it, use the regex command.

   | regex .\,
0 Karma

rajivchadha
New Member

I tried the rex command like below and it did not work as per your suggestion

index="md_dev" ( "Subscribe for") | rex max_match=0 "(?identifier=.*\,)"

also tried

index="md_dev" ( "Subscribe for") | rex max_match=0 "(?identifier=[.]*\,)"

which did not work

0 Karma

javiergn
Super Champion

Does "any character" include commas too?

If not, you can possibly do it like this:

"[^\,]+\,"

Which reads as 1 or more non-comma characters followed by a comma.

You can then group all of that in a token you want to capture, and problem solved.

| rex "(?<fieldnameFoo>[^\,]+)\,"

Thanks,
J

0 Karma

rajivchadha
New Member

Thanks. I tried what you suggested and it worked.

0 Karma
Get Updates on the Splunk Community!

Splunk Observability for AI

Don’t miss out on an exciting Tech Talk on Splunk Observability for AI! Discover how Splunk’s agentic AI ...

[Puzzles] Solve, Learn, Repeat: Dereferencing XML to Fixed-length events

This challenge was first posted on Slack #puzzles channelFor a previous puzzle, I needed a set of fixed-length ...

Stay Connected: Your Guide to December Tech Talks, Office Hours, and Webinars!

What are Community Office Hours? Community Office Hours is an interactive 60-minute Zoom series where ...