TopXML XSLT library : Padding with XSLT

Home Page

Add/Edit your code items

Search the code library

Browse for the code library

XSLT
XSLT
XSLT Contents
Preceding-subling XSL
Basic Shapes to Paths with TinyLine
XML to CSV using XSLT
Cross-Browser display of XML/XSL
Cross Reference Lookup in XSLT using XML file as Xref table
Recursion reminds me of Recursion (9 XSLT Recursion examples)
XSLT Sort - output entire xml file with new sort order
Variable Variables
Cross Reference Lookup in XSLT using embedded XML
XTrans 1.0
XML Explorer 2.5
Create an N-Column Table from XML node-set
XSLT Select Option Example
XSLT Date filtering, sorting, comparing, and evaluating
XSLT Template for HTML INPUT Tag
XSLT Template for HTML IMG Tag
XSLT Search and Replace Template
Word wrap and text replace templates for XSLT
nxslt 1.3
Visual XPath

<< XQuery .NET and XML >>

By	John Workman
First Posted	04/19/2003
Times viewed	1169

Padding with XSLT

This post contains attachments
v20030419195352.zip

Summary Template used to pad fields for fixed length flat file transforms. Also allows for truncation and left/right justification.

The following code demonstrates how to pad fields for fixed length file transforms. It will pad with zeros or spaces (or any other character), left or right justify, and will also truncate (if configured to do so) if the field is larger than the max size. If you set justification as right justified, and truncation to true, then the field will truncate to the left. Example: 'This is the name of the company', max=30, left justified, truncation = Y results: 'This is the name of the compan' 'This is the name of the company', max=30, right justified, truncation = Y results: 'his is the name of the company' You will often need to right justified, pad with zero, on numbers. My recommendation is to NOT truncate numbers. I prefer for the file to exceed the max length on the record than to truncate a number and have it import inaccurate information. Template used to pad fields for fixed length flat file transforms. Also allows for truncation and left and right justification. Updated on 9/23/2003 with fix to right justified, truncation issue.

Additional information
<?xml version='1.0'?> <xsl:stylesheet xmlns:xsl='http://www.w3.org/1999/XSL/Transform' version='1.0' xmlns:msxsl = 'urn:schemas-microsoft-com:xslt' xmlns:x='ignore'> <xsl:output omit-xml-declaration='yes'/>  <xsl:variable name='blank'><xsl:text> </xsl:text></xsl:variable> <xsl:variable name='delimiter'><xsl:text>|</xsl:text></xsl:variable>  <xsl:variable name='CompanyName_len' select='30'/> <xsl:variable name='InvoiceNumber_len' select='10'/> <xsl:variable name='Amt_len' select='10'/> <xsl:template match='/Doc'> <xsl:for-each select='line'> <xsl:value-of select='$delimiter' />  <xsl:call-template name='pad_Field'> <xsl:with-param name='justify' select='"L"'/>  <xsl:with-param name='trunc' select='"Y"'/>  <xsl:with-param name='max' select='$CompanyName_len'/> <xsl:with-param name='char' select='$blank'/>  <xsl:with-param name='value' select='@CompanyName'/> </xsl:call-template> <xsl:value-of select='$delimiter' />  <xsl:call-template name='pad_Field'> <xsl:with-param name='justify' select='"R"'/>  <xsl:with-param name='trunc' select='"N"'/> <xsl:with-param name='max' select='$InvoiceNumber_len'/> <xsl:with-param name='char' select='0'/>  <xsl:with-param name='value' select='@InvoiceNumber'/> </xsl:call-template> <xsl:value-of select='$delimiter' />  <xsl:call-template name='pad_Field'> <xsl:with-param name='justify' select='"R"'/>  <xsl:with-param name='trunc' select='"N"'/>  <xsl:with-param name='max' select='$Amt_len'/> <xsl:with-param name='char' select='0'/>  <xsl:with-param name='value' select='@Amt'/> </xsl:call-template> <xsl:value-of select='$delimiter' />  <xsl:value-of select='" "'/>  </xsl:for-each> </xsl:template>  <xsl:template name="pad_Field"> <xsl:param name="justify"/> <xsl:param name="trunc"/>  <xsl:param name="max" />  <xsl:param name="char" />  <xsl:param name="value" />   <xsl:variable name="trim-value"><xsl:value-of select="normalize-space($value)"/></xsl:variable> <xsl:if test="($justify = 'L')"> <xsl:if test="($trunc = 'Y')"> <xsl:value-of select="substring($trim-value,1,$max)" /> </xsl:if> <xsl:if test="($trunc = 'N')"> <xsl:value-of select="$trim-value" /> </xsl:if> </xsl:if>   <xsl:if test="(string-length($trim-value) < $max)"> <xsl:call-template name="pad"> <xsl:with-param name="num" select="0"/> <xsl:with-param name="max" select="$max - string-length($trim-value)"/> <xsl:with-param name="char" select="$char"/> </xsl:call-template> </xsl:if> <xsl:if test="($justify = 'R')"> <xsl:if test="$trunc='Y'"> <xsl:choose> <xsl:when test="$max < string-length($trim-value)"> <xsl:value-of select="substring($trim-value,string-length($trim-value)-$max+1,string-length($trim-value))" /> </xsl:when> <xsl:otherwise> <xsl:value-of select="$trim-value"/> </xsl:otherwise> </xsl:choose> </xsl:if> <xsl:if test="($trunc = 'N')"> <xsl:value-of select="$trim-value" /> </xsl:if> </xsl:if> </xsl:template>  <xsl:template name="pad"> <xsl:param name="num" /> <xsl:param name="max" /> <xsl:param name="char" /> <xsl:if test="not($num = $max)"> <xsl:value-of select="$char"/> <xsl:call-template name="pad"> <xsl:with-param name="num" select="$num + 1"/> <xsl:with-param name="max" select="$max"/> <xsl:with-param name="char" select="$char"/> </xsl:call-template> </xsl:if> </xsl:template> </xsl:stylesheet>

Further additional information
<Doc> <line business_date="4/10/2003" CompanyName="Company One" InvoiceNumber="123456" Amt="154323"/> <line business_date="4/10/2003" CompanyName="Company Two has a really long name" InvoiceNumber="123457" Amt="154323"/> </Doc>

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

Your vote :

<< XQuery .NET and XML >>


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



	Recent Jobs Software Specialist, Linux - Finland Linux Core Technical Project Manager/ Sc Graphics designer at Tanzania. Experienc Integration Specialist Needed - Work Fro Virtualization Server Infrastructure Arc View all Jobs (Add yours) View all CV (Add yours)



	Partners Dream.In.Code dotNet Slackers dotNet Spider Your HTML Source VisualBuilder.com DevGuru Planet Source Code ZVON.ORG Web Design ASPAlliance XML Pitstop Scripts The Spot 4 SAP Bitshop Web Hosting

Email TopXML