Oracle Transactional Business Intelligence

Products Banner

Remove line feed from OTBI Report

153
Views
2
Comments

Summary

Remove line feed from OTBI Report

Content

Hi all

Is there any way to remove line feed and carriage return from text columns in OTBI report?

I tried to define a new analysis sql in advanced tab and use instruction like "replace(OTBI column, chr(10), ' ')" , but i receive an error (message: OAMP2OPY:OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P:OI2DL65P)..

Thank you

Marco

 

Tagged:

Comments