BizTalk Utilities CV ,   Jobs ,   Code library
 
Home Page


Add/Edit your code items
Search the code library
Browse for the code library


Uncategorized
Extracting an item from a delimited list
Generating a Pivot Table from name-value pairs
Sorting on Dates and other Fixed Formats using the substring Function
Positional grouping by number of items
Parsing XML tag elements with VB string functions
getTemplate
getProcessor
Padding with spaces to a fixed-length string
Re: Swapping values in two integer variables without using a temporary variable
Swapping values in two integer variables without using a temporary variable
Comparing Multiple fields from the subquery
Re: Filtering unique values
Re: Grouping with totals/subtotals -- nested Muenchian method
Grouping with totals/subtotals -- nested Muenchian method
Generic JScript Function To Load XML Data
WebCube Report - Browser-based Multidimensional Data Reporting
The pow(a, b) function
Re: Missing constant definition
A simple template to display singular and plural counts
swapping two integer values without using temporary


 
 

<< System.XMLWCF, WS, SOAP >>


By Dimitre Novatchev
First Posted 12/03/2007
Times viewed 347

Date sorting (advanced) combined with the Muenchian Method for grouping


Summary This snippet illustrates the following: 1. Advanced date sorting (sort month-names) 2. The Muenchian Method for finding distinct elements 3. The use of (simulated) arrays within a stylesheet.

From the xml document listed below it is necessary to produce a list of accounts with a sorted list in descending order of all distinct dates for every account.

Notice how the simulated array $months is declared and used in the stylesheet to sort the elements of the xml source document.

The result is:
-------------
<date>December</date>
<date>July</date>
<date>June</date>
<date>April</date>
<date>March</date>

Additional information


Rate this article on a scale of 1 to 10 (0 votes, average 0)

Your vote :  

<< System.XMLWCF, WS, SOAP >>





Leave a comment for this article
Your name
Your email (optional)
Your comment
Optional: Upload an attachment
Enter the code shown:

 
 

    Email TopXML