Splunk Search

how to extract all values separately suing rex command

Puvi
New Member

hi,

i have a string like: AAA TEST BBB 1000 CCC DDD EEE FFF GG 11111
i need to extract all the values separately and display in table..
can you help me in this

Tags (2)
0 Karma

vnravikumar
Champion

Hi

Try this

| makeresults 
| eval test="AAA TEST BBB 1000 CCC DDD EEE FFF GG 11111" 
| rex field=test max_match=0 "(?<output>[^\s]+)" 
| mvexpand output 
| table output
0 Karma
Get Updates on the Splunk Community!

Webinar Recap | Revolutionizing IT Operations: The Transformative Power of AI and ML ...

The Transformative Power of AI and ML in Enhancing Observability   In the realm of IT operations, the ...

.conf24 | Registration Open!

Hello, hello! I come bearing good news: Registration for .conf24 is now open!   conf is Splunk’s rad annual ...

ICYMI - Check out the latest releases of Splunk Edge Processor

Splunk is pleased to announce the latest enhancements to Splunk Edge Processor.  HEC Receiver authorization ...