Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 44 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 278 Oracle Analytics and AI News
- 56 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Remove line feed from OTBI Report
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
Comments
-
Hey Marco,
The error may be related to OTBI trying to process CHR as a separate function. I tried to test with evaluate... but it's disabled on our pod (and probably yours).
EVALUATE('chr(%1)' AS INTEGER, 10)
Error: [nQSError: 43113] Message returned from OBIS. EVALUATE_SUPPORT_LEVEL inside NQSConfig.INI is not set to support EVALUATE. (HY000)
This can certainly be handled in a data model. You may also be able to figure out something in Column Properties -> Data Format, by using Javascript replace to make it work - https://docs.oracle.com/en/cloud/paas/bi-cloud/bilug/advanced-techniques-formatting-html-tags.html
While not a full answer, this may help get some conversation started.
Cheers.
0 -
Hi Marco,
you have to use char(10) not chr(10).
Try the below formula this will work.
replace(OTBI column, char(10), ' ')
Thanks
Nirmal
0