Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] (FOC280) How can I eliminate this space?

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] (FOC280) How can I eliminate this space?
 Login/Join
 
Chris Austin
Member
posted
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,


DevStudio 766 Servlet - Self Service - MS Windows XP SP2, (output) Excel, PDF, HTML
 
Posts: 12 | Registered: November 27, 2007Report This Post
Sayed
Guru
posted Hide Post
Can you upload expected output vs. actual output?

Sayed


WF 8.x and 7.7.x Win/UNIX/AS400, MRE/Portal/Self-Service, IIS/Tomcat, WebSphere, IWA, Realmdriver, Active Directory, Oracle, SQLServer, DB2, MySQL, JD Edwards, E-BIZ, SAP BW, R/3, ECC, ESSBASE
 
Posts: 285 | Location: Texas | Registered: June 27, 2006Report This Post
Chris Austin
Member
posted Hide Post
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!!!


DevStudio 766 Servlet - Self Service - MS Windows XP SP2, (output) Excel, PDF, HTML
 
Posts: 12 | Registered: November 27, 2007Report This Post
Jim Morrow
Platinum Member
posted Hide Post
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 = DATEWinkfor the concatenation to work


Jim Morrow
Web Focus 7.6.10 under Windows 2003
MVS 7.3.3



 
Posts: 129 | Registered: June 01, 2005Report This Post
Chris Austin
Member
posted Hide Post
That did the trick. THANK YOU!!!


DevStudio 766 Servlet - Self Service - MS Windows XP SP2, (output) Excel, PDF, HTML
 
Posts: 12 | Registered: November 27, 2007Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] (FOC280) How can I eliminate this space?

Copyright © 1996-2020 Information Builders