kikezelpbek
New Member
I am completely stuck. I am trying to use XLST to find/replace portions of my xml output file. I really don't even have starting point. I've tried using Altova DiffDog to automatically generate my xlst because I don't have a firm grasp on how to write it myself.This is my current xml output file:\[code\]<?xml version='1.0' encoding='UTF-8'?><BB:Report_Data xmlns:BB="urn:com.playdate.report/Report-Outbound"> <BB:Report_Entry> <BB:leaveBalanceTotal.employeeId>1234567</BB:leaveBalanceTotal.employeeId> <BB:leaveBalanceTotal.bmbId>9280136270</BB:leaveBalanceTotal.bmbId> <BB:All_Eligible_Time_Off_Plans_for_Worker> <BB:leaveBalanceTotal.leaveCodeId>1010</BB:leaveBalanceTotal.leaveCodeId> <BB:leaveBalanceTotal.balanceAmount>0</BB:leaveBalanceTotal.balanceAmount> <BB:leaveBalanceTotal.effectiveDate>2012-07-05</BB:leaveBalanceTotal.effectiveDate> <BB:leaveBalanceTotal.lastPayEndDate>2012-07-05</BB:leaveBalanceTotal.lastPayEndDate> </BB:All_Eligible_Time_Off_Plans_for_Worker> <BB:All_Eligible_Time_Off_Plans_for_Worker> <BB:leaveBalanceTotal.leaveCodeId>1014</BB:leaveBalanceTotal.leaveCodeId> <BB:leaveBalanceTotal.balanceAmount>96</BB:leaveBalanceTotal.balanceAmount> <BB:leaveBalanceTotal.effectiveDate>2012-07-05</BB:leaveBalanceTotal.effectiveDate> <BB:leaveBalanceTotal.lastPayEndDate>2012-07-05</BB:leaveBalanceTotal.lastPayEndDate> </BB:All_Eligible_Time_Off_Plans_for_Worker> <BB:leaveBalanceTotal.totalDaysService>1459</BB:leaveBalanceTotal.totalDaysService> </BB:Report_Entry></BB:Report_Data>\[/code\]This is what I need it to look like:\[code\]<?xml version='1.0' encoding='UTF-8'?><BB:Report_Data xmlns:BB="urn:com.playdate.report/Report-Outbound"> <leaveBalanceTotal> <leaveBalanceTotal.employeeId>1234567</leaveBalanceTotal.employeeId> <leaveBalanceTotal.bmbId>9280136270</leaveBalanceTotal.bmbId> <leaveBalanceTotal.leaveCodeId>1010</leaveBalanceTotal.leaveCodeId> <leaveBalanceTotal.balanceAmount>0</leaveBalanceTotal.balanceAmount> <leaveBalanceTotal.effectiveDate>2012-07-05</leaveBalanceTotal.effectiveDate> <leaveBalanceTotal.lastPayEndDate>2012-07-05</leaveBalanceTotal.lastPayEndDate> <leaveBalanceTotal.leaveCodeId>1014</leaveBalanceTotal.leaveCodeId> <leaveBalanceTotal.balanceAmount>96</leaveBalanceTotal.balanceAmount> <leaveBalanceTotal.effectiveDate>2012-07-05</leaveBalanceTotal.effectiveDate> <leaveBalanceTotal.lastPayEndDate>2012-07-05</leaveBalanceTotal.lastPayEndDate> <leaveBalanceTotal.totalDaysService>1459</leaveBalanceTotal.totalDaysService> </leaveBalanceTotal></BB:Report_Data>\[/code\]Essentially I am trying to remove all occurrences of the following:[*]BB:All_Eligible_Time_Off_Plans_for_Worker[*]/BB:All_Eligible_Time_Off_Plans_for_Worker[*]BB:And I need to replace Report_Entry with leaveBalanceTotal.Any help would be appreciated!