EBS Customizations (MOSC)

MOSC Banner

how to remove null space multiline output in oracle workflow notification

edited Jun 1, 2017 5:03AM in EBS Customizations (MOSC) 3 commentsAnswered

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">';

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center