I've been stumped by this one...the output lines seen below contain that gap for every record, and after trying it everyway I could think of, the only way to close it would be to somehow get it wrapped up in the same field, like I've done with the others. But that throws error (FOC280) COMPARISON BETWEEN COMPUTATIONAL AND ALPHA VALUES IS NOT ALLOWED. Any ideas?


*****************
*****OUTPUT******
*****************
USD/ABK.U/SEN |20081027|2515|2127|1781|0|1495|1331|1193|0|1148|1158|1133|
USD/AIG.U/SEN |20081027|1908|2184|2584|0|2316|2111|1936|0|1782|1679|1654|
USD/AW.U/SEN |20081027|0|0|0|0|175|180|215|0|0|0|0|
USD/BACORP.U/SEN |20081027|80|93|109|0|125|124|126|0|130|140|161|

*****************
*****PROGRAM*****
*****************
-SET &ECHO=ALL;
FILEDEF SAVEIT DISK \\...LEVELSfull.txt

DEFINE FILE CDSCOMPOSITESBYCONVENTION
CURR_CDS_DT/MDYY = DATE;
MARKITID/A200 = TICKER||TIER||CCY||DOCCLAUSE;
REF /A11 = STRIP(11,TICKER,' ',REF);
1Y /D5 = SPREAD1Y*100;
2Y /D5 = SPREAD2Y*100;
...
DEFINE FILE HOLD1
1Ys /A6 = FTOA(1Y,'(D5c)',1Ys);
2Ys /A6 = FTOA(2Y,'(D5c)',2Ys);
3Ys /A6 = FTOA(3Y,'(D5c)',3Ys);
5Ys /A6 = FTOA(5Y,'(D5c)',5Ys);
...
10Yt /A6 = STRIP(6,10Ys,' ',10Yt);
15Yt /A6 = STRIP(6,15Ys,' ',15Yt);
20Yt /A6 = STRIP(6,20Ys,' ',20Yt);
30Yt /A6 = STRIP(6,30Ys,' ',30Yt);
P /A1 = '|';
P2 /A1 = '/';
CUR /A3 = 'USD';
DEBTCLASS /A3 = 'SEN';
REFTCKR /A21 = CUR||P2||REF||('.U'|P2)||DEBTCLASS;
SPRDREC /A73 = P||1Yt||P||2Yt||P||3Yt||P||4Y||P||5Yt||P||7Yt||P||10Yt||P||12Y||P||15Yt||P||20Yt||P||30Yt||P;
END

TABLE FILE HOLD1
PRINT
REFTCKR P DATE SPRDREC
ON TABLE SAVE AS SAVEIT
END
-RUN
-QUIT

This message has been edited. Last edited by: Kerry,

Can you upload expected output vs. actual output?

Sayed

I appologize, I didn't see that it had shrunk in HTML...in the expected vs. actual I'm posting below - ______=spaces

EXPECTED OUTPUT
USD/ABK.U/SEN|20081027|2515|2127|1781|0|1495|1331|1193|0|1148|1158|1133|
USD/AIG.U/SEN|20081027|1908|2184|2584|0|2316|2111|1936|0|1782|1679|1654|
USD/AW.U/SEN|20081027|0|0|0|0|175|180|215|0|0|0|0|
USD/BACORP.U/SEN|20081027|80|93|109|0|125|124|126|0|130|140|161|

ACTUAL OUTPUT
USD/ABK.U/SEN___________|20081027|2515|2127|1781|0|1495|1331|1193|0|1148|1158|1133|
USD/AIG.U/SEN___________|20081027|1908|2184|2584|0|2316|2111|1936|0|1782|1679|1654|
USD/AW.U/SEN___________|20081027|0|0|0|0|175|180|215|0|0|0|0|
USD/BACORP.U/SEN_________|20081027|80|93|109|0|125|124|126|0|130|140|161|

THANKS!!!

The extra "inserted" spaces are the trailing space on REFTCKR /A21 I would try creating a single output field by hard concatenating ( || )everything. This will put the trailing spaces at the end. You will have to convert the date to an A8MDYY format (OUT_DAT/A8MDYY = DATEfor the concatenation to work

That did the trick. THANK YOU!!!