Wednesday, August 31, 2022

How to remove spaces in RTF Based Excel Output in Oracle APPS(XML Publisher Report)

Standard Trial Balance report output is Text. So client wanted to convert this report output to Excel. After converting standard Trial Balance report to excel we found issue like amount columns having leading and trailing spaces.


With this user unable to do SUM and other mathematical calculations. 

To remove spaces use below xdo function.
<?xdoxslt:trim(DISP_BEGIN_BALANCE)?>

This will remove leading and trailing spaces in Excel Output File.

No comments:

Post a Comment

Query to get the Concurrent Program along with Value Set details

SELECT fcpl1.user_concurrent_program_name       ,fdfcuv.end_user_column_name       ,ffvs.flex_value_set_name value_set_name       ,ffvt.appl...