Subject: Re: concat with unspecific length
From: henry human <henry_human@xxxxxxxx>
Date: Mon, 18 Jun 2012 15:50:52 +0100 (BST)
|
Sorry your function works fine!!! My mistake wa I overlooked..
Thanks
BR
hh
--- henry human <henry_human@xxxxxxxx> schrieb am Mo, 18.6.2012:
> Von: henry
human <henry_human@xxxxxxxx>
> Betreff: Re: concat with unspecific
length
> An: xsl-list@xxxxxxxxxxxxxxxxxxxxxx
> Datum: Montag, 18. Juni, 2012
16:29 Uhr
> hi Ken
> For this sample I had your concat works correctly but if
the
> field one(Field1) is less than 10 characters long the
> result is not
incorrect.
> The Fields must start ever at the same columns(in both
> samples
bellow):
>
> wrong result
> 2000090691 0010 2000090690 0010 //xml1.Field1
has
> length 10(2000090691)
> TP000001 0010 2000090229 0010 //
>
xml2.Field1 has length 8(TP000001)
>
> Correct result
> 2000090691 0010
2000090690 0010
> TP000001 0010 2000090229 0010
>
> BR
>
>
> --- G.
Ken Holman <gkholman@xxxxxxxxxxxxxxxxxxxx>
> schrieb am Mo, 18.6.2012:
>
> >
Von: G. Ken Holman <gkholman@xxxxxxxxxxxxxxxxxxxx>
> > Betreff: Re:
concat with unspecific length
> > An: xsl-list@xxxxxxxxxxxxxxxxxxxxxx,
>
"xslforum xslforum" <xsl-list@xxxxxxxxxxxxxxxxxxxxxx>
> > Datum: Montag, 18.
Juni, 2012 15:50 Uhr
> > 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
> >
> >
> >
>
--~------------------------------------------------------------------
> >
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@xxxxxxxxxxxxxxxxxxxxxx>
> > --~--
> >
> >
>
>
--~------------------------------------------------------------------
>
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@xxxxxxxxxxxxxxxxxxxxxx>
> --~--
|