Skip to main content

Working with Fixed Length Files

Fixed length files have a constant length for each field and record. In fixed-length text files, each field starts and ends at the same place in every record. Each new line is assumed as Row Separator. This article outlines how to use Fixed Length Files as a source in Ingestion activity.


Fixed Length Files are supported only as a Source and not a Target in Guzzle.

Text and Log File Properties in Guzzle#

PropertyDescriptionDefault ValueRequired
Character SetIt refers to the Set of Characters used to Read/Write test files. Allowed Values include: UTF-8, UTF-16 etc.UTF-8Yes
File PatternThis is the file name pattern to find matching files in the data store. Refer to Working with Multiple Files for more details on defining the patterNoneYes
Column ConfigurationGuzzle supports mapping the files by providing start and end position for the field. By mapping data flows in Guzzle, you can transform data from fixed-width text files. In other words we can set up Substring splits based on ordinal position. All we need to do is specify the Column Name and the Column Length/Range.
There are 2 ways we can specify the Column Specs:
Specifying the number of Characters for each field. These are read sequentially.
We can also specify the start position and the number of characters to read.

Note: We can read overlapping data as 2 different fields.
SG12313 as one of the field.
We can read:
SG as country
And SG12313 as ID number
Configure processed pathThe Configure Processed Paths feature allows the user to specify the directory and Guzzle moves the Data into that directory. When creating a processed file path Guzzle creates 3 subfolders: processed, rejected and partial.
For more information click here.
Configure control file settingsThe Configure Control File feature cross check whether a file is valid or not. It compares the number of records in the original file and the control file extension. Guzzle provides the Configure Control File feature for all local file formats including Delimited, JSON, XML, Excel and Fixed Length Files.
For more information click here.
Partial LoadSpecify partial loading of files.FalseNo

Interface for fixed length file is#