|
[XQuery Talk Mailing List Archive Home] [By Date] [By Thread] [By Subject] [By Author] [Recent Entries] [Reply To This Message] Whitespace problem in CSV-like outputPer Bothner per at bothner.comFri Oct 17 03:19:25 PDT 2008
Yves Forkl wrote: > Hi, > > from a very simple XML input, I would like to create a CSV-like > output, putting each record (as I see them) in a line of its own, with > its fields separated by some delimiter like a semicolon. A trick is to use text nodes, because that suppresses the extra spaces: let $entries := doc("file:/home/bothner/tmp/demo.xml")/list/entry for $property1 in distinct-values($entries/property1), $property2 in distinct-values($entries[property1 = $property1]/property2) let $selected_entries := $entries[property1 = $property1 and property2 = $property2] order by $property1, $property2 return( string-join( ($property1, $property2, replace(xs:string( sum(for $quantity in $selected_entries/quantity return xs:decimal(replace($quantity, ",", ".")))), "\.", ",")), ";"), text{" "}) Produces: A;33;2 B;22;0,5 (I haven't tested this on Saxon, just Qexo.)
|
PURCHASE STYLUS STUDIO ONLINE TODAY!Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced! Download The World's Best XML IDE!Accelerate XML development with our award-winning XML IDE - Download a free trial today! Subscribe in XML format
|






