Splunk Search

How to extract field with fieldname starts with a "#" ?

sonicant
Path Finder

Hi Guys

Recently I have been dealing with some application logs and met some difficulties with field extraction.
Every fieldname is started with a "#", such as #field1=xxx#field2=yyy#field3=zzz#...
Then splunk extracted fields like: field1="xxx#field2=yyy#field3=zzz". How to tell splunk to threat "#" as a comma or space (means ignore the #) ?

Would someone help me ? Thanks in advance!

The log format is like:

2012-04-16 17:41:27:087 [Inner-Tans-90013849] request:a60061152 102600 #oper_flag=1#user_type=2#user_id_type=1#user_id=1234567#user_pwd=897985d09890f41a4300#login_ip=192.168.1.1#bank_no=0000#net_envionment=2#net_agent=1#
2012-04-16 17:41:27:087 [Inner-Tans-90013849] 1.Start:com.klink.btrs.product.system.imp.T9006
2012-04-16 17:41:27:089 [Inner-Tans-90013849] com.klink.btrs.BtrsException: Invalid Username or password!
2012-04-16 17:41:27:095 [Inner-Tans-10023849] response:a60061152 102600 HJ9999 #rsp_msg=Invalid Username or password!#

Tags (2)
0 Karma
1 Solution

Damien_Dallimor
Ultra Champion

Take a look at the DELIMS property in transforms.conf

Example :

[foo]
DELIMS = "#", "="

View solution in original post

Damien_Dallimor
Ultra Champion

Take a look at the DELIMS property in transforms.conf

Example :

[foo]
DELIMS = "#", "="

Damien_Dallimor
Ultra Champion

Great! Happy Splunking 🙂

0 Karma

sonicant
Path Finder

Hi Damien,
Thank you!
I added:
[logtest]
DELIMS = "#", "="
in transforms.conf

and added:
[logtest]
REPORT-test = logtest
in props.conf, then it works!!

0 Karma
Get Updates on the Splunk Community!

Splunk Decoded: Service Maps vs Service Analyzer Tree View vs Flow Maps

It’s Monday morning, and your phone is buzzing with alert escalations – your customer-facing portal is running ...

What’s New in Splunk Observability – September 2025

What's NewWe are excited to announce the latest enhancements to Splunk Observability, designed to help ITOps ...

Fun with Regular Expression - multiples of nine

Fun with Regular Expression - multiples of nineThis challenge was first posted on Slack #regex channel ...