convert newline character to html tag in oracle sql 11g

Question

I am reading a file which has many descriptive fields of length 4000 bytes. While reading this file as a table I could not put the conditions into the source qualifier because it does not have enough space to put SQL in it.

Hence i decided to put replace newline character by spaces in a expression transformation.

I tried the following code:

REPLACECHR(0,SUPSPD_COMMUNICATION_PLAN, CHR(10)||CHR(11)||CHR(12),'<br/>')
I am getting < in the output.

How do i do this?

Answer 1

I guess you get the error as each time SQ gets a newline character, it treats this as a new row. You probably would need to do the replacement before reading the file with Informatica. Try sed or other command line tool you have available