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

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.

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

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

Try looking at the help files for FPRINT and you will see where you've made a mistake.

T

Looking up FPRINT in the manual would have been faster than posting here...

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

"Display Only" values are not valid. Hit the Search button, FPRINT, and, there are 7 pages of examples...

Hi,

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

Regards,
IP

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

Hi,

Thank you Tony...

Regards,
IP