All Apps and Add-ons

DB Connect V3 -Database data: Line breaking, case conversion

steelo_1
New Member

2018-06-13 07:50:45.491, NILL_UPDATE_TS="2018-06-13 07:34:26.390909", NILL_ACCESS_NBR="00000005562065", NILL_EMAIL_ADDR="xxx@gmail.com ", NILL_CHANNEL_CD="HBK", BULL_MODIFIED_TM="2018-06-13 07:51:30.340677", BULL_INT_ACC_NO="1234567878 ", NULL_ACCT_OWNER_UC="BAD CASE ", NULL_RTN="1111111111", NULL_ACCT_NO="56565656565656 ", BULL_TRANS_AMOUNT="500.00", BULL_STATUS="Scheduled ", NULL_MODIFIED_TM="2018-06-13 07:50:45.491481"

Data being pulled out of a database with dbconnect version 3 comes in as a single line per event as shown above.
I need to be able to:

1) convert and index all field names in lowercase
2) break output to have 1 key / value pair per line

Output should look as follows:

2018-06-05 07:50:45.491
nill_update_ts=2018-06-13 07:34:26.390909
nill_access_nbr=00000005562065
nill_email_addr=xxx@gmail.com
nill_channel_cd=HBK
bull_modified_tm=2018-06-13 07:51:30.340677
bull_int_acc_no=1234567878
null_acct_owner_uc=BAD CASE
null_rtn=1111111111
null_acct_no=56565656565656
bull_trans_amount=500.00
bull_status=Schedule
null_modified_tm=2018-06-13 07:50:45.491481

Any pointers?

0 Karma

jcoates
Communicator

that is not currently possible. However, you might enjoy this article: http://my2ndhead.blogspot.com/2017/07/heating-up-data-pipeline-part-1.html

0 Karma

steelo_1
New Member

dbconnect v1 did this automatically

0 Karma
Get Updates on the Splunk Community!

Splunk Observability Cloud | Unified Identity - Now Available for Existing Splunk ...

Raise your hand if you’ve already forgotten your username or password when logging into an account. (We can’t ...

Index This | How many sides does a circle have?

February 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

Registration for Splunk University is Now Open!

Are you ready for an adventure in learning?   Brace yourselves because Splunk University is back, and it's ...