Transform multilined element value to one line

ypomonh · April 27th, 2007, 06:46 AM

I have an element:

Code:

<query>SELECT 
A.NAME,A.CHR,B.WDS,C.DES,B.ROM,B.BED,A.PAT 
FROM T1 A,T2 B,T3 C 
WHERE A.PAT=B.PAT AND B.DEP=C.DEP AND A.TYP='S' AND A.DISD='31/12/2008' AND 
B.DATT='31/12/2009' ORDER BY A.NAME</query>

which spans multiple lines but I need it to be one line like:

Code:

<query>SELECT  A.NAME,A.CHR,B.WDS,C.DES,B.ROM,B.BED,A.PAT  FROM T1 A,T2 B,T3 C WHERE A.PAT=B.PAT AND B.DEP=C.DEP AND A.TYP='S' AND A.DISD='31/12/2008' AND B.DATT='31/12/2009' ORDER BY A.NAME</query>

Is there an xsl function for that?

mhkay · April 27th, 2007, 06:53 AM

Use normalize-space()

Michael Kay
http://www.saxonica.com/
Author, XSLT Programmer's Reference and XPath 2.0 Programmer's Reference

ypomonh · April 27th, 2007, 08:32 AM

Thank you very much for your prompt and helpful reply!