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(_at_)CraneSoftwrights(_dot_)com
Google+ profile: https://plus.google.com/116832879756988317389/about
Legal business disclaimers: http://www.CraneSoftwrights.com/legal
--~------------------------------------------------------------------
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--