Add the REPLACE sql function in order to do this function in AWE.
For instance:
<field alias="id" id="REPLACE(Ett+Cie+Nts+Prd+Dea,' ','')"/>