Remove Space

Content

Hi,

Below is the query which concatenates all the category names and provides in single column value which works fine. I have registered this report as ESS Job with the output as CSV.

 

But the only issue faced is I found one space as first character highlighted in red how can this be removed 

 

select

hzp.party_name,

rtrim(xmlagg(xmlelement(e,substr(category_name,1,8),',').extract('//text()') order by category_name).GetClobVal(),',') as Category_Codes

from poz_suppliers poz, hz_parties hzp, poz_supplier_sites_v psv,poz_sup_products_services psr ,egp_categories_tl psc