Versions Compared

Old Version 2

changes.mady.by.user Kirstin Seidel-Gebert

Saved on

compared with

New Version 3

changes.mady.by.user Kirstin Seidel-Gebert

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space WBRIDGE and version 22.1.1

...

Multiexcerpt
MultiExcerptNameFlatFileRecord
Tagged ValueDescriptionAllowed ValuesExample
attributeLayout

Defines the attribute layout (fixed or separated) of the flat file record.

  • Fixed: For attribute values that are shorter than the maximum length of the field, the field is filled with a fill character. As per default, this is blank space, but you can change the fill character in tagged value fillCharacter of the <<FlatFile>> class (see Tagged Values of Class <<FlatFile>>).
  • Separated: If separated is used, specify the separator using attributeSeparator (see below).
fixedfixed attribute layout
separatedseparated attribute layout
attributeSeparatorDefines the attribute/field separator.any characteruse this character as attribute separator
<Tab>use tabulator as attribute separator
attributePatternA RegEx pattern to parse the record content into the attributes using capture groups.a valid regular expression^(.?)(://)([A-Za-z0-9.])(:[0-9])(/.)$
evaluationOrderDefines the order in which the association of the classes starting on same parent class must be processed, see Flat File Adapter Parsing Process.any integer
ignoreEmptyRecords

Boolean value for ignoring empty records. If set to true, no item will be generated, if none of the defined attributes or sub records have any content.

Note
iconfalse

Note, that a record containing only empty Strings is not empty – in opposition to a record composed from NULLs. See ignoreEmptyStrings below to skip processing of records containing only empty Strings.

trueignore empty records
false (default)process empty records
ignoreEmptyStrings

Boolean value for ignoring empty string attributes. If set to true, empty string values will be processed to NULL.
Use this tag in combination with ignoreEmptyRecords to skip processing of records containing only empty Strings.

trueignore empty string values
false (default)preserve empty string values
lineNumberSpecifies the number of a record in the file. The first record is lineNumber=1, the second lineNumber=2, etc.any integer
pattern
Multiexcerpt
MultiExcerptNamepattern

A pattern to identify the record. The pattern is checked before the fields are separated. If no pattern is defined, all records will be parsed.

any character
a valid regular expression^Pattern.*
suppressEscaping

Boolean value to suppress escaping. If suppressEscaping on a <<FlatFileRecord>> is true, <<FlatFileComplexAttribute>> that are part of this record will inherit this setting.

trueattribute values of this record will not be un-escaped (parser) or escaped (composer)
falseescaping/un-escaping is not suppressed
parseMacro
Multiexcerpt
MultiExcerptNamemacro

A macros macro that is executed while parsing/composing a file or complex field.

This macro can contain multiple commands separated by commas or spaces. Macros on classes are executed before the processing of its attributes or associations. The ID represents a counter. Actually 8

The following counters are available:

  • eight automatic counters with ID AUTO0 .. AUTO7
  • two automatic line counters with ID LINE0 and LINE1 (parsing only)
  • unlimited custom counters with ID CUSTOM0 .. CUSTOMx

and 8 custom Counter CUSTOM0 .. CUSTOM 7 are available. Automatic counters are increased by 1 for each processed record. Custom counters have to be increased manually using the increase macro.
All counters have the initial value of 1 0 when they process the first record.

For more details on macro commands see Macro Expressions.

any valid macro expression (see Macro Expressions)GetCounter(AUTO0)
composeMacro

...