Re: [xsl] concat with unspecific length

Subject: Re: [xsl] concat with unspecific length
From: "G. Ken Holman" <gkholman@xxxxxxxxxxxxxxxxxxxx>
Date: Mon, 18 Jun 2012 09:50:05 -0400
At 2012-06-18 14:39 +0100, henry human wrote:
Hello
I have following xml bellow and want to concat together as here:
Field1 [from position 1, length varies] + " " [until position 11] +
Field2 [from position 12] + " " [until position 16]+ Field3 [from position 17, length always 10] +
" " [until position 27] + Field4



Input <Field1>2000090691</Field1>

<Field2>0010</Field2>

<Field3>2000090690</Field3>

<Field4>0010</Field14>

Pad each field with spaces and then take what you need:


concat(
substring(concat(Field1,'           '),1,11),
substring(concat(Field2,'    '),1,5),
substring(concat(Field3,'          '),1,10),
Field4
)

I hope this helps.

. . . . . . . . . . . Ken

--
Public XSLT, XSL-FO, UBL and code list classes in Europe -- Oct 2012
Contact us for world-wide XML consulting and instructor-led training
Free 5-hour lecture: http://www.CraneSoftwrights.com/links/udemy.htm
Crane Softwrights Ltd.            http://www.CraneSoftwrights.com/s/
G. Ken Holman                   mailto:gkholman@xxxxxxxxxxxxxxxxxxxx
Google+ profile: https://plus.google.com/116832879756988317389/about
Legal business disclaimers:    http://www.CraneSoftwrights.com/legal

Current Thread