Versions Compared
compared with
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).
Panel | ||||
---|---|---|---|---|
| ||||
Other Common Flat File Issues:
|
Overview
Content Tools