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.
New TIBCO Community Coming Soon
In early summer, TIBCO plans to launch a new community—with a new user experience, enhanced search, and expanded capabilities for member engagement with answers and discussions! In advance of that, the current myibi community will be retired on April 30. We will continue to provide updates here on both the retirement of myibi and the new community launch.
What You Need to Know about Our New Community
We value the wealth of knowledge and engagement shared by community members and hope the new community will continue cultivating networking, knowledge sharing, and discussion.
During the transition period, from April 20th until the new community is launched this summer, myibi users should access the TIBCO WebFOCUS page to engage.
I have a field which is of format D20.2 and since I need to append the % sign or the !sign to it, Iam trying to convert it into D12.2% or D12.2!D as per the below code:
TABLE FILE TABLE1 PRINT COL1 COL2/D12.2!D COL3/D12.2% ON TABLE PCHOLD FORMAT DFIX DELIMITER | HEADER YES END -RUN
But the % and the ! signs are not getting appended to the value and it works in other formats like html and excel.
Any thoughts/help on the same would be appreciated.
Thanks a lot in advance!
Regards, IPThis message has been edited. Last edited by: <Kathryn Henning>,
When you use a format option, it is for display purposes only (e.g. excel, html, pdf etc.). As you are HOLDing the data then these options do not apply. You can use FPRINT to convert if you need this within the HOLD file.
Alan. WF 7.705/8.007
Posts: 1451 | Location: Portugal | Registered: February 07, 2007
Iam trying the below format but it is not working : COMPUTE ALPHA_D/D20.2 = FPRINT(COL2,'D12.2!D', 'D20.2');
It is throwing the below error message : (FOC36355) INVALID TYPE OF ARGUMENT #3 FOR USER FUNCTION FPRINT (FOC009) INCOMPLETE REQUEST STATEMENT BYPASSING TO END OF COMMAND
Any hints/ideas on how to get it worked would be appreciated.
I had a look at the manual but even then I couldn't find anything related to the format I was looking for and hence posted here hoping to get some solution.
Have a look at the "output" type in the help page that Tom posted, it shows "alphanumeric". The clue is also in the title of the page - "FPRINT - Converting Fields to Alphanumeric Format"