Function to replace text

[rotem_fo]

try this:
select x ,
rpad(replace(y,'#',''),9) y,
rpad(replace(z,'#',''),6) z
from xyz
/