logo
down
shadow

XML to Fixed width text file formatted details


XML to Fixed width text file formatted details

By : Christian
Date : November 22 2020, 10:54 AM
around this issue I have an XML like this , How about:
XSLT 1.0
code :
<xsl:stylesheet version="1.0" 
xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="text" encoding="utf-8"/>

<xsl:variable name="spaces" select="'                              '"/>

<xsl:template match="/">
    <xsl:for-each select="Report/table1/Detail_Collection/Detail/PurchaseDetails">
        <xsl:apply-templates select="../ReceiptNo"/>
        <xsl:apply-templates select="../ReceiptDate"/>
        <xsl:apply-templates select="../LastName"/>
        <xsl:apply-templates select="../FirstName"/>
        <xsl:apply-templates select="Item"/>
        <xsl:call-template name="format-number">
            <xsl:with-param name="number" select="100 * Price"/>
        </xsl:call-template>
        <xsl:call-template name="format-number">
            <xsl:with-param name="number" select="Quantity"/>
        </xsl:call-template>
        <xsl:if test="position()!=last()">
            <xsl:text>&#10;</xsl:text>
        </xsl:if>
    </xsl:for-each>     
</xsl:template>

<xsl:template match="ReceiptNo | LastName | FirstName | Item">
    <xsl:value-of select="substring(concat(., $spaces), 1, 30)"/>
</xsl:template>

<xsl:template match="ReceiptDate">
    <xsl:value-of select="translate(., '/', '')"/>
</xsl:template>

<xsl:template name="format-number">
    <xsl:param name="number" select="0"/>
    <xsl:choose>
        <xsl:when test="$number >= 0">
            <xsl:value-of select="format-number($number, '000000000000000')"/>
        </xsl:when>
        <xsl:otherwise>
            <xsl:value-of select="format-number(-$number, 'N00000000000000')"/>
        </xsl:otherwise>
    </xsl:choose>
</xsl:template>

</xsl:stylesheet>
<xsl:text>  (300 spaces here)  </xsl:text>
<xsl:template match="ReceiptDate">
    <xsl:value-of select="concat(substring(., 7, 4), substring(., 1, 2), substring(., 4, 2))"/>
</xsl:template>


Share : facebook icon twitter icon
Parsing a fixed-width formatted file in Java

Parsing a fixed-width formatted file in Java


By : enqae
Date : March 29 2020, 07:55 AM
this will help I would use a flat file parser like flatworm instead of reinventing the wheel: it has a clean API, is simple to use, has decent error handling and a simple file format descriptor. Another option is jFFP but I prefer the first one.
Writing a fixed-width text file

Writing a fixed-width text file


By : Jekky
Date : March 29 2020, 07:55 AM
Hope this helps I would recommend using the new .NET methods for string manipulation rather than the old-style VB6 functions, for instance:
code :
Private Function ToLen(text As String, length As Integer)
    If text.Length > length Then
        Return text.SubString(0, length)
    Else
        Return text.PadRight(length)
    End If
End Function
Using MyFile1 As New StreamWriter("C:\Temp\MyFile.txt")
    Do
        ' loop through records
        MyFile1.Write(ToLen(Item1, 10))
        MyFile1.Write(ToLen(Item2, 50))
        MyFile1.WriteLine(ToLen(Item3, 25))
    Loop
End Using
How to read Fortran fixed-width formatted text file in Python?

How to read Fortran fixed-width formatted text file in Python?


By : J.Wróblewski
Date : March 29 2020, 07:55 AM
hope this fix your issue I have a Fortran formatted text file (here is 3 first rows):
code :
     columns = ((0,10),(11,14),(15,18),(19,22),(23,29),(30,35),
               (36,44),(44,45),(46,49),(50,55),(56,61),(62,67),
               (68,73),(74,79),(79,80),(81,86),(86,87),(88,108))
     string=file.readline()
     dataline = [ string[c[0]:c[1]] for c in columns ]
convert a fixed width file from text to csv

convert a fixed width file from text to csv


By : user3192475
Date : March 29 2020, 07:55 AM
wish helps you I have a large data file in text format and I want to convert it to csv by specifying each column length. , GNU awk (gawk) supports this directly with FIELDWIDTHS, e.g.:
code :
gawk '$1=$1' FIELDWIDTHS='4 2 5 1 1' OFS=, infile
aasd,fh,90135,1,2
ajsh,dj, 2445,d,f
F# Read Fixed Width Text File

F# Read Fixed Width Text File


By : ed_heck
Date : March 29 2020, 07:55 AM
this one helps. The hardest part is probably to split a single line according to the column format. It can be done something like this:
code :
let splitLine format (line : string) =
    format |> List.map (fun (index, length) -> line.Substring(index, length))
let result = lines |> List.map (splitLine format)
Related Posts Related Posts :
  • Default namespace in XML file doesn't work with XSD, why?
  • Spring 3.1 : Cannot find the declaration of element 'beans'
  • Merging similar attributes with XSLT
  • WSO2 ESB: XML response in WSO2 REST API call not parsed
  • Add image id to image path based on condition
  • How to test data of an XML file
  • how can i solve "No grammar constraints (DTD or XML Schema) referenced in the document." WARNING
  • Why does XML not display in browser but correctly does in XML Notepad 2007 (Microsoft)?
  • How to output based on the input conditions
  • Use parameter value as in select in xslt
  • Counting the number of times an xslt transform is done
  • Trouble using an environment variable's value in VBS
  • HTTP response containing XML book-ended by unexpected characters
  • Trying to retrieve just one node value in xslt
  • Select name of alias of xmlns atribute by xpath
  • Get and set text in a xml field
  • Need help to create an XSLT
  • Counting frequency of tags / attributes in XML using XSLT
  • Update nodes via merge without changing node order?
  • Flat to Hierarchical XSLT Transform
  • XSL Selecting A Nested Field (From Shopify XML Output)
  • How do I add a semi colon between text fragments but not at the end of text fragments?
  • Parse XSL Date Format
  • Network protocol structure definitions in machine readable form (xml,json,other?)?
  • invalid byte '?' at position 2 of 2-byte sequence validation/parse error
  • Inserting a node into XML
  • Replace before and after string in vim
  • XML/XSL Table won't populate
  • shadow
    Privacy Policy - Terms - Contact Us © ourworld-yourmove.org