By the way, I need to use this column in both prompt and report. So user can filter based on distinct value and pass this value to the report.
You may utilize database specific or BI functions to replace that unwanted lines
use evaluate with regexp_replace or number 13 to replace.
using OBI try to use ascii or char functions to identify and replace.
ascii will convert string to number (not what I want to achieve)
char will convert number to string (not what I want to achieve as well)
I need to remove chr(13) carriage return in OBI, not sure how to do it.
just throwing some hints... what to use..
just in case can you set HTML as data format and can you share screen?