View Single Post
  #3 (permalink)  
Old September 5th, 2006, 05:49 AM
pvasudevan pvasudevan is offline
Authorized User
 
Join Date: Nov 2003
Location: , , .
Posts: 42
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thank you Michael, that worked like a charm.

I have one more question about eliminating a particular value of the CSV row from the input file. For instance, if the input data is of the format:

1065,steo,PARIS_SPEND_DV_TPP,Enterprise:SAPPayroll
1015,steo,PARIS_FUTURE_LOK_TPP,Enterprise:SAPTrans actionsDetail

Then while transforming this data to the xml format, I'd like to skip the 3rd element such as PARIS_SPEND_DV_TPP & PARIS_FUTURE_LOK_TPP, such that the final output would be:

<UserAccessDS>
    <Access>
        <ww>1065</ww>
        <un>steo</un>
        <rl>Enterprise:SAPPayroll</rl>
    </Access>
    <Access>
        <ww>1015</ww>
        <un>steo</un>
        <rl>Enterprise:SAPTransactionsDetail</rl>
    </Access>
</UserAccessDS>

I guess I should modify inside <xsl:value-of select="."/> to achive this I suppose. Could you help me on this as well.

Many thanks,
Praveen

Reply With Quote