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?
... View more