how to remove null space multiline output in oracle workflow notification
Hi Team,
I have requirement in oracle workflow notification related.
Ship to address having address1,address2,address3,address4 and address5 values.
The requirement is two display in multiple line for SHIP TO ADDRESS FIELD
Am able to print as per the requirement but if any null spaces are coming in address4 and address3 its printing null ..
Output looks not good ..
How can we remove that spaces when we have null values
For reference output and corresponding code as shown
p_document_inout :=
p_document_inout
|| '<tr style="font-family:Arial,Helvetica,Geneva,sans-serif;font-size:x-small;text-align:Left;vertical-align:baseline;background-color:##e7e7e7;color:#17202a">';