Skip to main content
Skip table of contents

Using Patterns to Separate Attributes

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

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
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
^(.*?)(://)([A-Za-z0-9.]+)(:[0-9]+)*(/*.*)$

Each group delimited with brackets represents an record field (property of the flat file record class).

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.