Frends.FixedWidthFlatFile.Parse / 1.0.2

Summary

Splits fixed-width records into named fields using column width definitions, since the format carries no delimiters to infer structure from. An optional header row supplies the field names.

Typical use — mainframe and banking extracts, as the first step before converting or mapping

Details

Frends version: 5.5 and newer
Agent: Crossplatform
Target framework: net6.0

Parse Task input specification.

Name	Type	Default	Example	Description
FlatFileContent	`String`	–	`Name Street StartDate Veijo FrendsStr 20180527 Hodor HodorsStr 20180101`	Fixed width flat file content in string format.
HeaderRow	`HeaderRowType`	`FixedWidth`	`HeaderRowType.FixedWidth`	None: Flat file does not contain header row FixedWidth: Header row is parsed using column specification Delimited: Header row is parsed using delimiter char Possible values: `None`: None: Flat file does not contain header row FixedWidth: Header row is parsed using column specification Delimited: Header row is parsed using delimiter char `FixedWidth`: None: Flat file does not contain header row FixedWidth: Header row is parsed using column specification Delimited: Header row is parsed using delimiter char `Delimited`: None: Flat file does not contain header row FixedWidth: Header row is parsed using column specification Delimited: Header row is parsed using delimiter char
HeaderDelimiter	`String`	–	`;`	If header row uses delimiter set it here.
ColumnSpecifications	`ColumnSpecification[]`	–	`[ Example, ColumnType.String, yyyy-MM-ddTHH:mm:ss, 5 ]`	Column specifications for the data that is being parsed.