Versions Compared

Key

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

This page explains the Flat File Adapter in Bridge context. If you were looking for the same information regarding the PAS Designer, refer to Flat File Adapter in the Designer guide.

To split flat file record fields, you can also use regex patterns. However, you need deeper knowledge of regex patterns to use this approach.

Multiexcerpt include
MultiExcerptNameflatfile_pattern
PageWithExcerptINTERNAL:_examples_BRIDGE

Look at the example flat file below. It contains a list of URLs.

Figure: Flat File With URLs

Image Modified

By specifying an Attribute Pattern on the flat file record, you can split the records e.g. into

  • protocol
  • delimiter
  • host
  • port
  • path

Figure: Class Diagram of a Flat File Using Pattern

Image Modified

The pattern to split the record with is:

Code Block
^(.*?)(://)([A-Za-z0-9.]+)(:[0-9]+)*(/*.*)$

Each group delimited with brackets represents an record field (class attribute).