Versions Compared

Key

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

To split flat file record fields, you can also use regex patterns.

Info

You need deeper knowledge of regex patterns to use this approach.

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

Code Block
https://scheer-acme.com/home
https://scheer-acme.com/products
https://scheer-acme.com/pas/cust/service/ProductExport/ui/Product_export/00000019eec5983900004a6eb08a4700b3daa078/Show_export_file

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

  • protocol
  • delimiter
  • host
  • port
  • path

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 (property of the flat file record class).

rp
Panel
titleRelated Pages:

Other Common Flat File Issues:

Children Display
pageCommon Flat File Issues