RE: [xsl] Conversions for PeopleSoft input

Subject: RE: [xsl] Conversions for PeopleSoft input
From: "Shoe, Bridget" <bshoe@xxxxxxxxxx>
Date: Mon, 10 Mar 2003 15:45:52 -0500
EndDate is a element in the input. It's all very large, so I've cut some of it
out...

Input data looks like this

<?xml version="1.0"?>
<AsyncRequest>
  <data PsNonXml="Yes">
    <![CDATA[<SiebelMessage
 MessageId=""
 MessageType="Integration Object"
 IntObjectName="Quote">
<SiebelQuote>
<Quote>
<QuoteNumber>1-D5G2O</QuoteNumber>
<Revision>1</Revision>
<EndDate>02/06/2003 00:00:00</EndDate>
<CurrencyCode>USD</CurrencyCode>
<PaymentTerm></PaymentTerm>
<CountryofInstallation>United Kingdom</CountryofInstallation>
... Lots of additional fields/nodes
<QuoteItems>
<QuoteItem>
<LineNumber>1</LineNumber>
<PartNumber>0074060079</PartNumber>
<ItemPrice>19.53</ItemPrice>
<Quantity>1</Quantity>
<UnitofMeasure>Each</UnitofMeasure>
</QuoteItem>
<QuoteItem>
<LineNumber>2</LineNumber>
<PartNumber>0074060079</PartNumber>
<ItemPrice>20.53</ItemPrice>
<Quantity>1</Quantity>
<UnitofMeasure>Each</UnitofMeasure>
</QuoteItem>
....
</QuoteItems>
</Quote>
</SiebelQuote>
</SiebelMessage>
]]>
  </data>
</AsyncRequest>

-----Original Message-----
From: David N Bertoni/Cambridge/IBM [mailto:david_n_bertoni@xxxxxxxxxx]
Sent: Monday, March 10, 2003 3:09 PM
To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx
Subject: Re: [xsl] Conversions for PeopleSoft input






> Hi,
>            Can someone tell me why this does not work?  I am trying
> to convert the date from a Siebel format to a PeopleSoft format.
>
> Input data is date in format:  MM/DD/YYYY HH:MM:SS
> i.e: 02/06/2003 00:00:00
>
> I need the output as YYYY-MM-DD
>
> XSLT that I am trying to use to transform this is:
>
> <QUOTE_DUE_DATE><xsl:value-of select="concat(substring(EndDate, 7, 4),
'-',
> substring(EndDate, 1, 2), '-', substring(EndDate, 4, 2))"/>
>                                                </QUOTE_DUE_DATE>

It would help if you gave us more information.  For example, what does the
input data look like?  Is EndDate an element in the input XML, does it
contain the correct string, and is it a child of the current node?  Or
perhaps EndDate is a variable, and you simply forgot the '$' character?

<QUOTE_DUE_DATE>
  <xsl:value-of select="concat(substring($EndDate, 7, 4), '-',
substring($EndDate, 1, 2), '-', substring($EndDate, 4, 2))"/>
</QUOTE_DUE_DATE>

Dave


 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list

 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list


Current Thread