topic Rex field in Splunk Enterprise

Rex field

Azwaliyana — Mon, 15 Nov 2021 14:01:18 GMT

I want to extract the Country and the Node. When I use the rex in regex101, it works fine. But when I put it on Splunk search, it did not extract the Country and the Node. Do you guys know where is my mistake?

This is my search query.

index="maxis_csaroam_index" source="/home/csaops/csaroam/*_MOS.csv" | dedup Description | table Description | rex field=Description "(?<Country>[\w]+)(?<Node>[\w\- ]*\n)"

Re: Rex field

ITWhisperer — Mon, 15 Nov 2021 14:46:37 GMT

Try without the newline in the match

| rex field=Description "(?<Country>[\w]+)(?<Node>[\w\- ]+)"

Re: Rex field

bhargavi — Mon, 15 Nov 2021 16:54:09 GMT

Hi @Azwaliyana ,

Try this.

| rex field=Description "(?<Country>\w+)\s(?<Node>\w*\-?\w+)"

Re: Rex field

somesoni2 — Tue, 16 Nov 2021 14:16:32 GMT

Give this a try (avoided using dedup command as well, best practice)

index="maxis_csaroam_index" source="/home/csaops/csaroam/*_MOS.csv" | stats count by Description | table Description | rex field=Description "(?<Country>\S+)\s+(?<Node>\S+)"