Splunk Search

How can I extract the fields from log file?

nayagan
Engager

I need to split the below log files to like excel table.

My Log file is:

2022-05-25 13:00:02 100.200.190.70 - test [12345]dele /TestingFile+-+END+-+GOD+WEL+SOONER+-+SFTP.txt - 220- 105 - 443
2022-06-30 12:05:08 200.231.150.150 - welcome [98765]created /TestingFileFromSource+-+COME+-+THE+END+Server+-+FileName.csv - 226 - 19 - 22

Expected Result is: ( I tried some regular expression but no luck)

Field1 Field2 Field3 Field4 Field5 Field6 Field7 Field8 Field9
2022/05/25 13:00:02 100.200.190.70 test 12345 dele TestingFile END GOD WEL sooner SFTP.txt 220 105 443
2022/06/30 12:05:08 200.231.150.150 welcome 98765 created TestingFileFromSource COME THE END Sending FileName.csv 226 19 22
Labels (3)
Tags (1)
0 Karma

nayagan
Engager

Hi @gcusello - Thank you for your support, It is working fine now.  How to remove "+-+" in the field6. I need only file as TestingFileFromSource COME THE END Server FileName.csv instead of TestingFileFromSource+-+COME+-+THE+END+Server+-+FileName.csv

0 Karma

gcusello
Esteemed Legend

Hi @nayagan,

please try this regex

^(?<field1>\d+-\d+-\d+ \d+:\d+:\d+)\s+(?<field2>\d+\.\d+\.\d+\.\d+)\s+-\s+(?<field3>\w+)\s+\[(?<field4>\d+)\](?<field5>\w+)\s+\/(?<field6>.+)-\s+(?<field7>\d+)\s+-\s+(?<field8>\d+)\s+-\s+(?<field9>\d+)

that you can test at https://regex101.com/r/ozkFFe/1

Ciao.

Giuseppe

Get Updates on the Splunk Community!

SplunkTrust | Where Are They Now - Michael Uschmann

The Background Five years ago, Splunk published several videos showcasing members of the SplunkTrust to share ...

Admin Your Splunk Cloud, Your Way

Join us to maximize different techniques to best tune Splunk Cloud. In this Tech Enablement, you will get ...

Cloud Platform | Discontinuing support for TLS version 1.0 and 1.1

Overview Transport Layer Security (TLS) is a security communications protocol that lets two computers, ...