Fixed Width

Can be one of the following types:

The 'Row Extractor' defines how each table row is identified in the source text. For each match produced by this extractor, a table row will be created and parsed according to the record layout.

• Use a Pattern Match or other suitable extractor to match the start and end of each logical row.
• Ensure that the extractor matches the full width of each row as defined by the record layout.

If the row extractor does not match the expected row length, extraction may fail or produce incomplete data.

The 'Record Layout' property specifies how each row should be split into columns, using a Lexicon with key-value pairs where the key is the column name and the value is the column width (in characters).

• You can define the layout directly or reference an existing Lexicon.

• Each entry should be in the format ColumnName=Width, for example:

  Record Type=4 Sequence=8 Run Date=10 ID=8 Amount=14

• The sum of all column widths should match the total length of each row as matched by the row extractor.

This property is required for accurate parsing of fixed-width data.

The 'Trim' property controls whether leading and trailing whitespace is removed from each extracted column value.

• Set to true (default) to automatically trim whitespace, which is common in fixed-width formats.
• Set to false to preserve all whitespace, which may be necessary for certain data types or formats.

Adjust this property based on the requirements of your downstream processing or data validation.