To fetch the specific values in xml to xsl

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • deepab1983
    New Member
    • Mar 2010
    • 5

    To fetch the specific values in xml to xsl

    I need to fetch the data from xml and the values to be formatted in xsl to my desire. Please help


    <REPORT>
    <DATA>
    <RECEIPTNUMBER> CR/2/08-09</RECEIPTNUMBER>
    <RECEIPTDATE> 05-MAR-2009</RECEIPTDATE>
    </DATA>
    </REPORT>

    The receipt number is displayed with a prefix and suffix CR and 08-09. I have to view only the number of the reciept as 2. Is there any possibilities to fetch and display the number in the report.
  • rski
    Recognized Expert Contributor
    • Dec 2006
    • 700

    #2
    You can use a combnation of functions
    substring-before and subtring-after to get the number only

    Comment

    • jkmyoung
      Recognized Expert Top Contributor
      • Mar 2006
      • 2057

      #3
      Are these prefixes constant?

      probably a substring-before (substring-after / ) /
      sort of deal.

      Comment

      • deepab1983
        New Member
        • Mar 2010
        • 5

        #4
        Thank you

        Thank you for your response.
        Its works fine

        Comment

        Working...