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] D12.2% or D12.2!D not working in text format

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] D12.2% or D12.2!D not working in text format
 Login/Join
 
info4pal
Guru
posted
Hi,

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,
IP

This message has been edited. Last edited by: <Kathryn Henning>,


Webfocus 8105 Developer studio,Windows 7,HTML,Excel,PDF,Text,Infoassist,Graph,AHTML
 
Posts: 270 | Registered: October 30, 2014Report This Post
Alan B
Virtuoso
posted Hide Post
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, 2007Report This Post
info4pal
Guru
posted Hide Post
Hi,

Thanks Alan for the quick response and for the solution.
I will try it and will let you know if it works or not.

Regards,IP


Webfocus 8105 Developer studio,Windows 7,HTML,Excel,PDF,Text,Infoassist,Graph,AHTML
 
Posts: 270 | Registered: October 30, 2014Report This Post
info4pal
Guru
posted Hide Post
Hi,

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.

Thanks a lot in advance!

Regards,
IP


Webfocus 8105 Developer studio,Windows 7,HTML,Excel,PDF,Text,Infoassist,Graph,AHTML
 
Posts: 270 | Registered: October 30, 2014Report This Post
Tony A
Expert
posted Hide Post
Try looking at the help files for FPRINT and you will see where you've made a mistake.

T


In FOCUS
since 1986		WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report This Post
Tom Flynn
Expert
posted Hide Post
Looking up FPRINT in the manual would have been faster than posting here...



Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
 
Posts: 1972 | Location: Centennial, CO | Registered: January 31, 2006Report This Post
info4pal
Guru
posted Hide Post
Hi Tom,

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.

Anyways thanks a lot !

Regards,
IP


Webfocus 8105 Developer studio,Windows 7,HTML,Excel,PDF,Text,Infoassist,Graph,AHTML
 
Posts: 270 | Registered: October 30, 2014Report This Post
Tom Flynn
Expert
posted Hide Post
"Display Only" values are not valid. Hit the Search button, FPRINT, and, there are 7 pages of examples...


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
 
Posts: 1972 | Location: Centennial, CO | Registered: January 31, 2006Report This Post
info4pal
Guru
posted Hide Post
Hi,

Thanks a lot Tom.
Iam looking into those pages only.

Regards,
IP


Webfocus 8105 Developer studio,Windows 7,HTML,Excel,PDF,Text,Infoassist,Graph,AHTML
 
Posts: 270 | Registered: October 30, 2014Report This Post
Tony A
Expert
posted Hide Post
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"

quote:
COMPUTE ALPHA_D/D20.2 = FPRINT(COL2,'D12.2!D', 'D20.2');


The D20.2 format of your computed field is not alphanumeric it is numeric. Hence the error message that you receive.


T


In FOCUS
since 1986		WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report This Post
info4pal
Guru
posted Hide Post
Hi,

Thank you Tony...

Regards,
IP


Webfocus 8105 Developer studio,Windows 7,HTML,Excel,PDF,Text,Infoassist,Graph,AHTML
 
Posts: 270 | Registered: October 30, 2014Report 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] D12.2% or D12.2!D not working in text format

Copyright © 1996-2020 Information Builders