Getting Data In

How do I line break after a particular word?

vrmandadi
Builder

Hello
Below is a sample one sample event which starts with ####### and ends with * All done!. How do I break the events correctly?
Thanks in advance

#######################
Program: FADBDataLoader.pl
Begin Processing: Mon Aug 27 09:38:15 2018
Executing from: linuxbatch-prod
Working Directory: /opt/apps/FADB/Support

Command:  FADBDataLoader.pl 
No override date provided from command-line.
Will use database override OR date card file instead.

Connecting to fadbprd as ... success!

Calling 'GMRUSER.CHECK_OVERRIDE_DATE' to get possible override process date
execProcCursor(): Executing GMRUSER.CHECK_OVERRIDE_DATE with 3 parameters
    (FADB_UX_SS_MMKT_FNAV_LOAD, SSB, <cursor>)

Procedure returned value: 

No date found in database table...
Process date file:  /opt/apps/FADB/Support/process_date_am.dat
Process date:       08/27/2018
Control Date will be checked against Processing Date
Validating data file with LMFadbUtils::validate_ssmmkt_fnav_intraday routine...
Calling 'GMRUSER.SSB_MMKT_FNAV_LOAD' to load data.
ExecProc(): Executing GMRUSER.SSB_MMKT_FNAV_LOAD with 4 parameters
    (20180827, SSB, FADB_UX_SS_MMKT_FNAV_LOAD,  )

Parsing the database output...
* Begin Money Market FNAV load into FADB.TBL_FNAV_INTRADAY
* from GMRUSER.STAGE_MMR_FNAV
* of 4 stage records for SSB (2) 
* dated 27 Aug 2018
* Updated 4 of 4 custodian IDs. within staging table.
* Strike time found: 0800
* Updating control date in stage table...
* Updated 4 of 4 Account IDs within staging table.
* Updated 4 of 4 instrument IDs. within staging table.
* Number of prior run records to be deleted: 0
* Inserted 4 of 4 rows into FADB.TBL_FNAV_INTRADAY.

Sending Rejections
execProcCursor(): Executing GMRUSER.GET_REJECTIONS with 4 parameters
    (08/27/2018, FADB_UX_SS_MMKT_FNAV_LOAD, 2, <cursor>)

No Rejections Found.
ExecProc(): Executing GMRUSER.BO_REPORT_JOB_STATUS_INS with 2 parameters
    (08/27/2018, FADB_UX_SS_MMKT_FNAV_LOAD)

execProcCursor(): Executing GMRUSER.BO_REPORT_JOB_STATUS_CHECK with 3 parameters
    (08/27/2018, FADB_UX_SS_MMKT_FNAV_LOAD, <cursor>)

ExecProc(): Executing GMRUSER.BO_REPORT_JOB_STATUS_UPD with 2 parameters
    (08/27/2018, FADB_UX_SS_MMKT_FNAV_LOAD)

Calling 'FADB.GET_FEED_FILE_ARCH_FLAG' to get mult. archive flag
execProcCursor(): Executing FADB.GET_FEED_FILE_ARCH_FLAG with 2 parameters
    (FADB_UX_SS_MMKT_FNAV_LOAD, <cursor>)




--------------------------------------------------------------------------------


### DATABASE LOGGING INFORMATION ###

Job Name:   FADB_UX_SS_MMKT_FNAV_LOAD
Batch ID:   SSB
Process Date:   08/27/2018
JOB_ID:     741
RUN_NUMBER: 1

* Inserting log for STDOUT output to database...
* Inserted 99 rows into the table for run number 1
* Inserting log for STDERR output to database...
* Inserted 21 rows into the table for run number 1
* All done!
0 Karma
1 Solution

richgalloway
SplunkTrust
SplunkTrust

Try this in your props.conf:

LINE_BREAKER = (#######################)
SHOULD_LINEMERGE = true
TIME_PREFIX = Begin Processing: 
TIME_FORMAT = %a %b %d %H:%M:%S %Y
---
If this reply helps you, Karma would be appreciated.

View solution in original post

mstjohn_splunk
Splunk Employee
Splunk Employee

hi @vrmandadi,

Did the answer below solve your question? If yes, please click “Accept” directly below the answer to resolve the post. If not, please comment with more information if you are still having issues.

0 Karma

richgalloway
SplunkTrust
SplunkTrust

Try this in your props.conf:

LINE_BREAKER = (#######################)
SHOULD_LINEMERGE = true
TIME_PREFIX = Begin Processing: 
TIME_FORMAT = %a %b %d %H:%M:%S %Y
---
If this reply helps you, Karma would be appreciated.

pruthvikrishnap
Contributor

try adding this props.conf
[sourcetype]
NO_BINARY_CHECK = true
BREAK_ONLY_BEFORE =

0 Karma

skoelpin
SplunkTrust
SplunkTrust

LINE_BREAKER is better than BREAK_ONLY_BEFORE

0 Karma
Career Survey
First 500 qualified respondents will receive a $20 gift card! Tell us about your professional Splunk journey.

Can’t make it to .conf25? Join us online!

Get Updates on the Splunk Community!

Can’t Make It to Boston? Stream .conf25 and Learn with Haya Husain

Boston may be buzzing this September with Splunk University and .conf25, but you don’t have to pack a bag to ...

Splunk Lantern’s Guide to The Most Popular .conf25 Sessions

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...

Unlock What’s Next: The Splunk Cloud Platform at .conf25

In just a few days, Boston will be buzzing as the Splunk team and thousands of community members come together ...