Remove line feed from OTBI Report

Marco Francia

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

 

Wade Wilson

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.

Nirmal-64675

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

http://www.dataterrain.com