How do i convert this XSLT to tab delimited csv file
Here should go questions about transforming XML with XSLT and FOP.
-
- Posts: 2
- Joined: Thu Apr 11, 2019 4:27 am
How do i convert this XSLT to tab delimited csv file
Post by deepag0303 »
Hi,
I am new to XSLT & oXygen. I have already xslt code which usually transform the data to CSV text file with COMMA delimted but I would like to modify this code to transform the data into CSV with TAB DELIMITED FILE. Could you please help to alter this.
And also please guide me some materials to learn basics.
Thanks,
Deepa.
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:ws="urn:com.workday/workersync" xmlns:xtt="urn:com.workday/xtt" xmlns:etv="urn:com.workday/etv" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" exclude-result-prefixes="xs ws" version="2.0">
<xsl:output method="xml"/>
<xsl:template match="/">
<File xmlns:xtt="urn:com.workday/xtt" xtt:quotes="csv" xtt:separator="
">
<xsl:for-each select="ws:Worker_Sync/ws:Worker/ws:Additional_Information">
<xsl:variable name="Current_date">
<xsl:value-of select="current-date()"/>
</xsl:variable>
<Record xtt:separator="," xtt:quotes="csv">
<PositionName>
<xsl:value-of select="ws:PositionName"/>
</PositionName>
<EffectiveStartDate xtt:dateFormat="MM/dd/yyyy">
<xsl:value-of select="$Current_date"/>
</EffectiveStartDate>
<EffectiveEndDate xtt:dateFormat="MM/dd/yyyy">
<xsl:value-of select="ws:EffectiveEndDate"/>
</EffectiveEndDate>
<EmployeeID>
<xsl:value-of select="ws:EmployeeID"/>
</EmployeeID>
<PayeeType>
<xsl:value-of select="ws:PayeeType"/>
</PayeeType>
<PlanName>
<xsl:value-of select="''"/>
</PlanName>
<ManagerName>
<xsl:value-of select="ws:ManagerName"/>
</ManagerName>
<TitleName>
<xsl:value-of select="ws:JobCode"/>
</TitleName>
<PositionGroupName>
<xsl:value-of select="''"/>
</PositionGroupName>
<TargetCompensation>
<xsl:value-of select="''"/>
</TargetCompensation>
<UnitTypeForTargetCompensation>
<xsl:value-of select="''"/>
</UnitTypeForTargetCompensation>
<BusinessUnitName>
<xsl:value-of select="ws:BusinessUnitName"/>
</BusinessUnitName>
<Description>
<xsl:value-of select="''"/>
</Description>
<JobTitle>
<xsl:value-of select="ws:JobTitle"/>
</JobTitle>
<JobProfile>
<xsl:value-of select="ws:JobProfile"/>
</JobProfile>
<TeamNumber>
<xsl:value-of select="''"/>
</TeamNumber>
<GENERICATTRIBUTE4>
<xsl:value-of select="ws:Location"/>
</GENERICATTRIBUTE4>
<GENERICATTRIBUTE5>
<xsl:value-of select="ws:PlanNo"/>
</GENERICATTRIBUTE5>
<GENERICATTRIBUTE6>
<xsl:value-of select="''"/>
</GENERICATTRIBUTE6>
<GENERICATTRIBUTE7>
<xsl:value-of select="''"/>
</GENERICATTRIBUTE7>
<GENERICATTRIBUTE8>
<xsl:value-of select="''"/>
</GENERICATTRIBUTE8>
<GENERICATTRIBUTE9>
<xsl:value-of select="''"/>
</GENERICATTRIBUTE9>
<GENERICATTRIBUTE10>
<xsl:value-of select="''"/>
</GENERICATTRIBUTE10>
<GENERICATTRIBUTE11>
<xsl:value-of select="''"/>
</GENERICATTRIBUTE11>
<GENERICATTRIBUTE12>
<xsl:value-of select="''"/>
</GENERICATTRIBUTE12>
<GENERICATTRIBUTE13>
<xsl:value-of select="''"/>
</GENERICATTRIBUTE13>
<GENERICATTRIBUTE14>
<xsl:value-of select="''"/>
</GENERICATTRIBUTE14>
<GENERICATTRIBUTE15>
<xsl:value-of select="''"/>
</GENERICATTRIBUTE15>
<GENERICATTRIBUTE16>
<xsl:value-of select="''"/>
</GENERICATTRIBUTE16>
<GENERICNUMBER1>
<xsl:value-of select="''"/>
</GENERICNUMBER1>
<UNITTYPEFORGENERICNUMBER1>
<xsl:value-of select="''"/>
</UNITTYPEFORGENERICNUMBER1>
<GENERICNUMBER2>
<xsl:value-of select="''"/>
</GENERICNUMBER2>
<UNITTYPEFORGENERICNUMBER2>
<xsl:value-of select="''"/>
</UNITTYPEFORGENERICNUMBER2>
<GENERICNUMBER3>
<xsl:value-of select="''"/>
</GENERICNUMBER3>
<UNITTYPEFORGENERICNUMBER3>
<xsl:value-of select="''"/>
</UNITTYPEFORGENERICNUMBER3>
<GENERICNUMBER4>
<xsl:value-of select="''"/>
</GENERICNUMBER4>
<UNITTYPEFORGENERICNUMBER4>
<xsl:value-of select="''"/>
</UNITTYPEFORGENERICNUMBER4>
<GENERICNUMBER5>
<xsl:value-of select="''"/>
</GENERICNUMBER5>
<UNITTYPEFORGENERICNUMBER5>
<xsl:value-of select="''"/>
</UNITTYPEFORGENERICNUMBER5>
<GENERICNUMBER6>
<xsl:value-of select="''"/>
</GENERICNUMBER6>
<UNITTYPEFORGENERICNUMBER6>
<xsl:value-of select="''"/>
</UNITTYPEFORGENERICNUMBER6>
<GENERICDATE1>
<xsl:value-of select="ws:JobEntryDate"/>
</GENERICDATE1>
<GENERICDATE2>
<xsl:value-of select="''"/>
</GENERICDATE2>
<GENERICDATE3>
<xsl:value-of select="''"/>
</GENERICDATE3>
<GENERICDATE4>
<xsl:value-of select="''"/>
</GENERICDATE4>
<GENERICDATE5>
<xsl:value-of select="''"/>
</GENERICDATE5>
<GENERICDATE6>
<xsl:value-of select="''"/>
</GENERICDATE6>
<GENERICBOOLEAN1>
<xsl:value-of select="''"/>
</GENERICBOOLEAN1>
<GENERICBOOLEAN2>
<xsl:value-of select="''"/>
</GENERICBOOLEAN2>
<GENERICBOOLEAN3>
<xsl:value-of select="''"/>
</GENERICBOOLEAN3>
<GENERICBOOLEAN4>
<xsl:value-of select="''"/>
</GENERICBOOLEAN4>
<GENERICBOOLEAN5>
<xsl:value-of select="''"/>
</GENERICBOOLEAN5>
<GENERICBOOLEAN6>
<xsl:value-of select="''"/>
</GENERICBOOLEAN6>
<CREDITSTARTDATE>
<xsl:value-of select="''"/>
</CREDITSTARTDATE>
<CREDITENDDATE>
<xsl:value-of select="''"/>
</CREDITENDDATE>
<PROCESSINGSTARTDATE>
<xsl:value-of select="''"/>
</PROCESSINGSTARTDATE>
<PROCESSINGENDDATE>
<xsl:value-of select="''"/>
</PROCESSINGENDDATE>
</Record>
</xsl:for-each>
</File>
</xsl:template>
</xsl:stylesheet>
I am new to XSLT & oXygen. I have already xslt code which usually transform the data to CSV text file with COMMA delimted but I would like to modify this code to transform the data into CSV with TAB DELIMITED FILE. Could you please help to alter this.
And also please guide me some materials to learn basics.
Thanks,
Deepa.
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:ws="urn:com.workday/workersync" xmlns:xtt="urn:com.workday/xtt" xmlns:etv="urn:com.workday/etv" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" exclude-result-prefixes="xs ws" version="2.0">
<xsl:output method="xml"/>
<xsl:template match="/">
<File xmlns:xtt="urn:com.workday/xtt" xtt:quotes="csv" xtt:separator="
">
<xsl:for-each select="ws:Worker_Sync/ws:Worker/ws:Additional_Information">
<xsl:variable name="Current_date">
<xsl:value-of select="current-date()"/>
</xsl:variable>
<Record xtt:separator="," xtt:quotes="csv">
<PositionName>
<xsl:value-of select="ws:PositionName"/>
</PositionName>
<EffectiveStartDate xtt:dateFormat="MM/dd/yyyy">
<xsl:value-of select="$Current_date"/>
</EffectiveStartDate>
<EffectiveEndDate xtt:dateFormat="MM/dd/yyyy">
<xsl:value-of select="ws:EffectiveEndDate"/>
</EffectiveEndDate>
<EmployeeID>
<xsl:value-of select="ws:EmployeeID"/>
</EmployeeID>
<PayeeType>
<xsl:value-of select="ws:PayeeType"/>
</PayeeType>
<PlanName>
<xsl:value-of select="''"/>
</PlanName>
<ManagerName>
<xsl:value-of select="ws:ManagerName"/>
</ManagerName>
<TitleName>
<xsl:value-of select="ws:JobCode"/>
</TitleName>
<PositionGroupName>
<xsl:value-of select="''"/>
</PositionGroupName>
<TargetCompensation>
<xsl:value-of select="''"/>
</TargetCompensation>
<UnitTypeForTargetCompensation>
<xsl:value-of select="''"/>
</UnitTypeForTargetCompensation>
<BusinessUnitName>
<xsl:value-of select="ws:BusinessUnitName"/>
</BusinessUnitName>
<Description>
<xsl:value-of select="''"/>
</Description>
<JobTitle>
<xsl:value-of select="ws:JobTitle"/>
</JobTitle>
<JobProfile>
<xsl:value-of select="ws:JobProfile"/>
</JobProfile>
<TeamNumber>
<xsl:value-of select="''"/>
</TeamNumber>
<GENERICATTRIBUTE4>
<xsl:value-of select="ws:Location"/>
</GENERICATTRIBUTE4>
<GENERICATTRIBUTE5>
<xsl:value-of select="ws:PlanNo"/>
</GENERICATTRIBUTE5>
<GENERICATTRIBUTE6>
<xsl:value-of select="''"/>
</GENERICATTRIBUTE6>
<GENERICATTRIBUTE7>
<xsl:value-of select="''"/>
</GENERICATTRIBUTE7>
<GENERICATTRIBUTE8>
<xsl:value-of select="''"/>
</GENERICATTRIBUTE8>
<GENERICATTRIBUTE9>
<xsl:value-of select="''"/>
</GENERICATTRIBUTE9>
<GENERICATTRIBUTE10>
<xsl:value-of select="''"/>
</GENERICATTRIBUTE10>
<GENERICATTRIBUTE11>
<xsl:value-of select="''"/>
</GENERICATTRIBUTE11>
<GENERICATTRIBUTE12>
<xsl:value-of select="''"/>
</GENERICATTRIBUTE12>
<GENERICATTRIBUTE13>
<xsl:value-of select="''"/>
</GENERICATTRIBUTE13>
<GENERICATTRIBUTE14>
<xsl:value-of select="''"/>
</GENERICATTRIBUTE14>
<GENERICATTRIBUTE15>
<xsl:value-of select="''"/>
</GENERICATTRIBUTE15>
<GENERICATTRIBUTE16>
<xsl:value-of select="''"/>
</GENERICATTRIBUTE16>
<GENERICNUMBER1>
<xsl:value-of select="''"/>
</GENERICNUMBER1>
<UNITTYPEFORGENERICNUMBER1>
<xsl:value-of select="''"/>
</UNITTYPEFORGENERICNUMBER1>
<GENERICNUMBER2>
<xsl:value-of select="''"/>
</GENERICNUMBER2>
<UNITTYPEFORGENERICNUMBER2>
<xsl:value-of select="''"/>
</UNITTYPEFORGENERICNUMBER2>
<GENERICNUMBER3>
<xsl:value-of select="''"/>
</GENERICNUMBER3>
<UNITTYPEFORGENERICNUMBER3>
<xsl:value-of select="''"/>
</UNITTYPEFORGENERICNUMBER3>
<GENERICNUMBER4>
<xsl:value-of select="''"/>
</GENERICNUMBER4>
<UNITTYPEFORGENERICNUMBER4>
<xsl:value-of select="''"/>
</UNITTYPEFORGENERICNUMBER4>
<GENERICNUMBER5>
<xsl:value-of select="''"/>
</GENERICNUMBER5>
<UNITTYPEFORGENERICNUMBER5>
<xsl:value-of select="''"/>
</UNITTYPEFORGENERICNUMBER5>
<GENERICNUMBER6>
<xsl:value-of select="''"/>
</GENERICNUMBER6>
<UNITTYPEFORGENERICNUMBER6>
<xsl:value-of select="''"/>
</UNITTYPEFORGENERICNUMBER6>
<GENERICDATE1>
<xsl:value-of select="ws:JobEntryDate"/>
</GENERICDATE1>
<GENERICDATE2>
<xsl:value-of select="''"/>
</GENERICDATE2>
<GENERICDATE3>
<xsl:value-of select="''"/>
</GENERICDATE3>
<GENERICDATE4>
<xsl:value-of select="''"/>
</GENERICDATE4>
<GENERICDATE5>
<xsl:value-of select="''"/>
</GENERICDATE5>
<GENERICDATE6>
<xsl:value-of select="''"/>
</GENERICDATE6>
<GENERICBOOLEAN1>
<xsl:value-of select="''"/>
</GENERICBOOLEAN1>
<GENERICBOOLEAN2>
<xsl:value-of select="''"/>
</GENERICBOOLEAN2>
<GENERICBOOLEAN3>
<xsl:value-of select="''"/>
</GENERICBOOLEAN3>
<GENERICBOOLEAN4>
<xsl:value-of select="''"/>
</GENERICBOOLEAN4>
<GENERICBOOLEAN5>
<xsl:value-of select="''"/>
</GENERICBOOLEAN5>
<GENERICBOOLEAN6>
<xsl:value-of select="''"/>
</GENERICBOOLEAN6>
<CREDITSTARTDATE>
<xsl:value-of select="''"/>
</CREDITSTARTDATE>
<CREDITENDDATE>
<xsl:value-of select="''"/>
</CREDITENDDATE>
<PROCESSINGSTARTDATE>
<xsl:value-of select="''"/>
</PROCESSINGSTARTDATE>
<PROCESSINGENDDATE>
<xsl:value-of select="''"/>
</PROCESSINGENDDATE>
</Record>
</xsl:for-each>
</File>
</xsl:template>
</xsl:stylesheet>
Jump to
- Oxygen XML Editor/Author/Developer
- ↳ Feature Request
- ↳ Common Problems
- ↳ DITA (Editing and Publishing DITA Content)
- ↳ SDK-API, Frameworks - Document Types
- ↳ DocBook
- ↳ TEI
- ↳ XHTML
- ↳ Other Issues
- Oxygen XML Web Author
- ↳ Feature Request
- ↳ Common Problems
- Oxygen Content Fusion
- ↳ Feature Request
- ↳ Common Problems
- Oxygen PDF Chemistry
- ↳ Feature Request
- ↳ Common Problems
- Oxygen Feedback
- ↳ Feature Request
- ↳ Common Problems
- Oxygen XML WebHelp
- ↳ Feature Request
- ↳ Common Problems
- XML
- ↳ General XML Questions
- ↳ XSLT and FOP
- ↳ XML Schemas
- ↳ XQuery
- NVDL
- ↳ General NVDL Issues
- ↳ oNVDL Related Issues
- XML Services Market
- ↳ Offer a Service