add some of the fields of an XML together with XSLT (but not all) -

-

i great noob xslt concerned. copied , pasted stuff forum, , works. however, finetune. can find examples of how concat fields, nog how concat of fields.

i have xml 

      <xs:element name="medewerker_x">         <xs:complextype>           <xs:sequence>             <xs:element name="medewerker" type="xs:string" minoccurs="0" />             <xs:element name="roepnaam" type="xs:string" minoccurs="0" />             <xs:element name="voorletters" type="xs:string" minoccurs="0" />             <xs:element name="voorvoegsel" type="xs:string" minoccurs="0" />             <xs:element name="achternaam" type="xs:string" minoccurs="0" />             <xs:element name="e-mail_werk" type="xs:string" minoccurs="0" />           </xs:sequence>         </xs:complextype>       </xs:element>  <medewerker_x>   <medewerker>654654</medewerker>   <roepnaam>mark</roepnaam>   <voorletters>mab</voorletters>   <achternaam>puist</achternaam>   <email>lala@test.com</email> </medewerker_x> <medewerker_x>   <medewerker>084680</medewerker>   <roepnaam>maarten</roepnaam>   <voorletters>m</voorletters>   <voorvoegsel>ter</voorvoegsel>   <achternaam>doornemalen</achternaam>   <email>sweetie@test.com</email> </medewerker_x>

with xslt 

<xsl:strip-space elements="*" />  <xsl:template match="/*/child::*"> <xsl:for-each select="child::*"> <xsl:if test="position() != last()"><xsl:value-of select="normalize-space(.)"/>;</xsl:if> <xsl:if test="position()  = last()"><xsl:value-of select="normalize-space(.)"/>    <xsl:text>&#xd;</xsl:text> </xsl:if> </xsl:for-each> </xsl:template>

it outputs this:

654654;mark;mab;puist;lala@test.com 084680;maarten;m;ter;doornemalen;sweetie@test.com

what have output this, of fields concatenated (and others no relevant):

mark puist;lala@test.com maarten ter doornemalen;sweetie@test.com

order of fields not relevant, additional fields can there, don't mind. long 2 columns present.

can me?

edited

i think input xml (note have added root node named <root>)

<root> <medewerker_x>   <medewerker>654654</medewerker>   <roepnaam>mark</roepnaam>   <voorletters>mab</voorletters>   <achternaam>puist</achternaam>   <email>lala@test.com</email> </medewerker_x> <medewerker_x>   <medewerker>084680</medewerker>   <roepnaam>maarten</roepnaam>   <voorletters>m</voorletters>   <voorvoegsel>ter</voorvoegsel>   <achternaam>doornemalen</achternaam>   <email>sweetie@test.com</email> </medewerker_x> </root>

with xslt:

<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/xsl/transform"     version="1.0">     <xsl:output method="text"/>      <xsl:template match="/">         <!-- now,  we'll loop each child `medewerker_x` of root node -->         <xsl:for-each select="root/medewerker_x">             <!-- if position greater 1, add linebreak before -->             <xsl:if test="position() &gt; 1">                 <xsl:text>&#xa;</xsl:text>             </xsl:if>             <!-- let loop of target child elements -->             <xsl:for-each select="*[self::roepnaam or self::voorvoegsel or self::achternaam or self::email]">                 <xsl:choose>                     <!-- test position of elements. in input xml,                           `email` last child element                     -->                     <xsl:when test="position() = last()">                         <xsl:text>;</xsl:text>                         <xsl:value-of select="."/>                     </xsl:when>                     <!-- tests 2nd last position -->                     <xsl:when test="position() = last()-1">                         <xsl:value-of select="."/>                     </xsl:when>                     <xsl:otherwise>                         <xsl:value-of select="."/>                         <xsl:text> </xsl:text>                     </xsl:otherwise>                 </xsl:choose>             </xsl:for-each>         </xsl:for-each>     </xsl:template>  </xsl:stylesheet>

it outputs:

mark puist;lala@test.com maarten ter doornemalen;sweetie@test.com

Comments

Post a Comment

Popular posts from this blog

matlab - "Contour not rendered for non-finite ZData" -

-
i'm trying plot frequency characteristic equation using ezplot, matlab gives following warning, "contour not rendered non-finite zdata". have used command plot frequency equations warning , plot display empty , not change axis range well. can please help. appreciated. here's code i'm using. % transfer matrix case-i, thin rotor clear all; clc; ei = 1626; l = 0.15; m = 0.44108; = 2.178*10^-4; i_p = 2.205*10^-5; itr = 0.24; i_pr = 0.479; syms p n; f = [1 l*1i l^2/(2*ei)*1i l^3/(6*ei); 0 1 l/ei -l^2/(2*ei)*1i; 0 0 1 -l*1i; 0 0 0 l]; p = [ 1 0 0 0; 0 1 0 0; 0 -it*p^2+i_p*n*p 1 0; -m*p^2 0 0 1]; p_r = [1 0 0 0; 0 1 0 0; 0 -itr*p^2+i_pr*n*p 1 0; -m*p^2 0 0 1]; = f*p*f*p*f*p*f; b = p_r*f*p*f*p*f; r = a(1,2)/a(1,4); a12_p = 0; a22_p = a(2,2)-r*a(2,4); a32_p = a(3,2)-r*a(3,4); a42_p = a(4,2)-r*a(4,4); ap(2,2) = a22_p; ap(3,2) = a32_p; ap(4,2) = a42_p; ap(4,4) = 1; c = b*ap; m = [c(3,2) c(3,4); c(4,2) c(4,...
Read more

delphi - Indy UDP Read Contents of Adata -

-
i using indy udp server read string of data. however, not know how work adata parameter. can around converting binary using bytetobin function below , convert hex using bintohex1 . feel stupid , works slow. know how can directly results without 2 conversions? thanks!! here codes: procedure tform1.idudpserver1udpread(athread: tidudplistenerthread; const adata: tidbytes; abinding: tidsockethandle); var buf: tidbytes; buffer: string; data_received: string; begin if bytestostring(adata) <> 'hello' begin buffer := hextostring('00'); setlength(buf, length(buffer)); copytidstring(buffer, buf, 0); abinding.sendto(abinding.peerip, abinding.peerport, buf); data_received := bintohex1(bytetobin(adata[1]) + bytetobin(adata[2]) + bytetobin(adata[3]) + bytetobin(adata[4]) + bytetobin(adata[5]) + bytetobin(adata[6]) + bytetobin(adata[7]) + bytetobin(adata[8]) + bytetobin(adata[9]) + bytetobin(adata[10]) + bytetobin(adata[11...
Read more

qt - How to embed QML toolbar and menubar into QMainWindow -

-
i using qwt library plot data. seems not possible embed qwidget qml quick 2 . so, decided create qmainwindow main window , create toolbar , menubar using quick controls . how should embed qml toolbar , menubar qmainwindow ? you should create qml applicationwindow qml menubar , toolbar main.qml applicationwindow { visible: false menubar: menubar { menu { title: "edit" menuitem { text: "cut" } } } toolbar: toolbar { row { anchors.fill: parent toolbutton { iconsource: "1.png" } } } } main.cpp qapplication app(argc, argv); qqmlapplicationengine engine; engine.load(qurl(qstringliteral("qrc:///main.qml"))); then pointer applicationwindow qwindow *qmlwindow = qobject_cast<qwindow*>(engine.rootobjects().at(0)); create window container, using qwidget::createwindowco...
Read more