Hi,
Is there a way to print an address without the blank lines. I am producing an email which includes the delivery address but looks un tidy because of the blank rows in the address. I am using an event with plsql code.
Thanks
Solved
Address formatting
Best answer by Tracy Norwillo
For example:
select company
, company_api.get_name(company) name
, address_presentation_api.format_address(country_db, address1, address2, address3, address4, address5, address6, city, county, state, zip_code, country ) address
from company_address
For example:
select company
, company_api.get_name(company) name
, address_presentation_api.format_address(country_db, address1, address2, address3, address4, address5, address6, city, county, state, zip_code, country ) address
from company_address
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.