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. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at firstname.lastname@example.org and provide your corporate email address, company, and name.
Not sure why such behavior, this could be the reason. When you add percentage symbol to the end of the title, excel treats it as a calculation and omits the symbol. When you force it to consider as Alpha format, then it works fine. Hope this will help.
TABLE FILE CAR
PRINT CAR AS 'CAR12345' OVER
COMPUTE TEST/I4 = 10 * 10; AS 'PMU%'
ON TABLE HOLD AS HLD_1 FORMAT HTMTABLE
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
<meta http-equiv=Content-Type content="text/html;">
<meta name=ProgId content=Excel.Sheet>
<meta name=Generator content="Microsoft Excel 10">
This seems to work. But I think it might be worthwhile to open a case with IBI to determine why the % sign fails to appear with format EXL2K.
TABLE FILE CAR
SUM CAR AS 'Car'
DEALER_COST AS 'PMU%'
ACROSS COUNTRY AS ''
ON TABLE SET ASNAMES ON
ON TABLE HOLD FORMAT HTMTABLE
Posts: 1213 | Location: Seattle, Washington - USA | Registered: October 22, 2007
Thought of posting as this is a relevant thread. In spite of trying with the .mht (Excel) format option, I am still not able to get the % symbol in the Excel output. To isolate the issue. Please check the below example TABLE FILE CAR PRINT COMPUTE TEST/A600V = 'SAMP%LE%'; CAR ON TABLE PCHOLD FORMAT EXL2K END For PDF, % is being displayed on the O/P for col TEST. For excel its simply showing as SAMPLE. However if i change the data type from A600V to A575V it is working fine. Not sure why it is getting broken after A575V. Please assist. Thanks.
Thanks for your prompt response. I am able to get the expected output as 'SAMP%LE%' in the Command console. However when the same is getting executed in any of the Dev or Stage environemnts (FEX file) it is coming as 'SAMPLE' for the same A600V. Not sure if I need to keep some SET commands.