Fixed Width Parser

Overview

This Snap reads binary data from its input view, extracts field values based on the field configuration, and writes document data to its output view.

Snap views

Type Description Examples of upstream and downstream Snaps
Input This Snap has exactly one binary input view, where it gets the binary data to be parsed for fixed length columns. JSON Generator
Output This Snap has exactly one document output view, where it provides a document data stream. Each document contains the extracted field values. All fields in the document data are of string-type. The Mapper (Data) Snap can be used to transform the data type from string-type to required type. Group By Fields

Mapper

Learn more about Error handling.

Snap settings

Legend:
  • Expression icon (): Allows using pipeline parameters to set field values dynamically (if enabled). SnapLogic Expressions are not supported. If disabled, you can provide a static value.
  • SnapGPT (): Generates SnapLogic Expressions based on natural language using SnapGPT. Learn more.
  • Suggestion icon (): Populates a list of values dynamically based on your Snap configuration. You can select only one attribute at a time using the icon. Type into the field if it supports a comma-separated list of values.
  • Upload : Uploads files. Learn more.
Learn more about the icons in the Snap settings dialog.
Field/Field set Type Description
Label String

Required. Specify a unique name for the Snap. Modify this to be more appropriate, especially if more than one of the same Snaps is in the pipeline.

Default value: Fixed Width Formatter

Example: Fixed Width Formatter
Skip lines String/Expression Number of lines to skip at beginning of the data.

Default value: 0

Example: 2

Line separator String/Expression The character used to separate lines in the input. Leave empty to separate lines using new line character or specify the character used for separating lines.

Default value: \n

Example: \n

Field configuration Details to be filled for each field that is required in the output.
Column names String/Expression Required. Column names to be used as headers for the extracted values.

Default value: [None]

Example: First Name; Last Name

Start position String/Expression Required. Starting position of each column to be used while extracting field values.

Default value: [None]

Example: 1

End position String/Expression Required. Ending position of each column to be used while extracting field values.

Default value: [None]

Example: 25

Trim column data String/Expression Required. If removal of leading and trailing spaces is required on the extracted data

Default value: False

Ignore Lines This is a table property allows user to ignore lines in the input document satisfying the provided condition.
Function String/Expression This is an LOV property having functions to be applied on the data line to be ignored.
Values:
  • startsWith: To ignore a line starting with specific value.
  • endsWith: To ignore a line ending with specific value.
  • contains: To ignore a line containing specific value.
  • regex: To ignore a line with data in provided regular expression format.

Default value: [None]

Example: First Name; Last Name

Value String Required. The value to be used for the function. If this value is empty then that property is ignored.

Default value: [None]

Example: 1

Snap execution Dropdown list

Select one of the three modes in which the Snap executes.

  • Validate & Execute: Performs limited execution of the Snap, and generates a data preview during Pipeline validation. Subsequently, performs full execution during Pipeline runtime.
  • Execute only: Performs full execution of the Snap during Pipeline execution without generating preview data.
  • Disabled: Disables the Snap and all Snaps that are downstream from it.

Default value: Execute only

Example: Validate & Execute