[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] RE: Conversions for PeopleSoft input
The most likely explanation, without seeing your code, is that EndDate is not a child of the context node at the point where you do this computation. Michael Kay Software AG home: Michael.H.Kay@xxxxxxxxxxxx work: Michael.Kay@xxxxxxxxxxxxxx > -----Original Message----- > From: owner-xsl-list@xxxxxxxxxxxxxxxxxxxxxx > [mailto:owner-xsl-list@xxxxxxxxxxxxxxxxxxxxxx] On Behalf Of > Shoe, Bridget > Sent: 10 March 2003 20:46 > To: 'xsl-list@xxxxxxxxxxxxxxxxxxxxxx' > Subject: RE: Conversions for PeopleSoft input > > > 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: 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 > XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
|
PURCHASE STYLUS STUDIO ONLINE TODAY!Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced! Download The World's Best XML IDE!Accelerate XML development with our award-winning XML IDE - Download a free trial today! Subscribe in XML format
|