triming data in write.xml

i"m using write.xml to write xml files from ms sql server table. the problem is that the information is not trimed... so i get lines like-
<data>1                                             </data>
are there is a way to trim the data even if i use write.xml mathod? 
...