Thursday, 14 April 2016

XML : Why does comma appear in my Xquery and how to get rid of it?

I have an xml file which looks like this.

     <Movies>       <Movie>              <Title>1 2 3</Title>              <Year>1985</Year>       </Movie>    </Movies>    

I am trying to run this xquery.

     let $alltitles := Movies//Movie/Title     let $allyear := Movies//Movie/Year     let $d :=concat($alltitles/text(),',',$allyear/text())  return $d.    

But when that returns it says 1, 2 , 3.

Why is comma automatically added? and how do I get the title without having commas in them?

No comments:

Post a Comment