DSXchange

Hi All,

Need to read the below complex .dat file in datastage, anyone help me,

Sample Data:


DOM01002194 CDS - REPORTING SYSTEM 12-05-18
EXCHANGE TRADE REPORT (DOMESTIC) 03:16:56
PAGE: 1

Market Id: AATS Trade Date : 12-05-17
Cuid: DOMA Ledger: DOM01 RBC DOMINION SECURITIES INC Value Date : 12-05-23

Other Curr Mode Seller-
Cuid Trans-Id Tag No Par\Qty Price Funds Amount ency Time Sett Buyer-Inf Type
----- -------- ------ ------------------- ----- ------------------ ---- ---- ---- --------- ----

Security Number: CA00762VAC33 Description: AECON 7% CNV SUB DEB 093014 Symbol: ARE.DB *******

FIDC Y12139-E128A 120517B02328 14,000 105.490000000 -14,910.90 CAD 09:38:10 TFT RTGEARL DP
FIDC Y12139-E128B 120517B02328 2,000 105.490000000 -2,130.13 CAD 09:38:10 TFT RTGEARL DP

SECURITY TOTAL - CAD
Buys : 16,000 -17,041.03
Sells: 0 16,000 .00 -17,041.03
SECURITY TOTAL - USD
Buys : 0 .00
Sells: 0 0 .00 .00

Security Number: CA04878QAN30 Description: ATLANTIC PWR 5.6% SER B 063017 Symbol: ATP.DB.B *******

FIDC Y12139-E1PVD 120517B23332 5,000 102.000000000 -5,211.22 CAD 15:47:08 TFT RTDCLAN DP

SECURITY TOTAL - CAD
Buys : 5,000 -5,211.22
Sells: 0 5,000 .00 -5,211.22
SECURITY TOTAL - USD
Buys : 0 .00
Sells: 0 0 .00 .00

Security Number: CA04963YAA07 Description: ATRIUM 5.75% CONV DEB 083118 Symbol: ATB.DB *******

WGDB Y12139-E1QK2 120517B09262 6,000 95.000000000 -5,779.40 CAD 11:39:02 TFT RTBMCCO DP

SECURITY TOTAL - CAD
Buys : 6,000 -5,779.40
Sells: 0 6,000 .00 -5,779.40
SECURITY TOTAL - USD
Buys : 0 .00
Sells: 0 0 .00 .00

Security Number: CA09950MAC60 Description: BORALEX 6.75% CNV 06/30/2017 Symbol: BLX.DB *******

WGDB Y12139-E3H9K 120517S11829 -1,000 104.010000000 1,066.73 CAD 12:25:26 TFT RTBPOUN DP

SECURITY TOTAL - CAD
Buys : 0 .00
Sells: -1,000 -1,000 1,066.73 1,066.73
SECURITY TOTAL - USD
Buys : 0 .00
Sells: 0 0 .00 .00


DOM01002194 CDS - REPORTING SYSTEM 12-05-18
EXCHANGE TRADE REPORT (DOMESTIC) 03:16:56
PAGE: 2

Market Id: AATS Trade Date : 12-05-17
Cuid: DOMA Ledger: DOM01 RBC DOMINION SECURITIES INC Value Date : 12-05-23

So... a report printed to a file. What have you tried?

The short answer is you read it by defining it as one long string and then parsing out the individual fields you are looking for inside the job, propably based on the first value in the string. Lots of the informational will just be noise and be skipped.

If you need specific help, you'd need to post what information you need out of the report and what your output / target is.