You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to skip the rows while reading the file using OICS

edited Aug 5, 2019 1:11PM in Integration 1 comment

Summary

Data file which I tries to import has some header text of 25 rows approximately, is there a way to skip these rows while reading the file using file adapter in OICS

Content

sample file ,

 

START-OF-FILE
RUNDATE=20190315

FIRMNAME=d12345
SN=12345
USERNUMBER=12345
FILETYPE=pc
REPLYFILENAME=GBMRates.dat
TIME=0900
CLOSINGVALUES=yes
PROGRAMFLAG=daily
SECMASTER=yes
PROGRAMNAME=getdata

# Automatically generated by Bloomberg Data License Request Builder version 6.0.5
# Build Code: 000000000000000123

START-OF-FIELDS
ID_BB_GLOBAL
PX_BID
PX_ASK
END-OF-FIELDS

TIMESTARTED=Fri Mar 15 09:01:02 GMT 2019
START-OF-DATA
XPTUSD CMPN Curncy|0|3|BBG0013HG9F3|832.960000|833.600000|
XPDUSD CMPN Curncy|0|3|BBG0013HG945|1554.760000|1558.700000|

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!