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?
that is not currently possible. However, you might enjoy this article: http://my2ndhead.blogspot.com/2017/07/heating-up-data-pipeline-part-1.html
dbconnect v1 did this automatically