Pattern Properties

What is a Pattern?

A Pattern is a logic or rule based on which we define data regions. You can specify a pattern that Astera matches on the unstructured data file to capture data into a structured format. A pattern can be an alphabet, a character, a number, a word, or a combination of these.

Specifying a Pattern

We specify a pattern in the pattern box right above the Report Model designer.

Astera has built-in wild cards to facilitate region selection by specifying flexible patterns. These wildcards are found in the toolbar located at the top of Report Model designer.

A short description of each wildcard is given below.

Wild Cards

Description

Ã

It matches any alphabet in the file.

Ñ

It matches any digit in the file.

Æ

It matches any alphabet or digit in the file.

Ø

It matches any non-blank character in the file.

ß

It matches any blank character such as line, space, tab etc. in the file.

Pattern Properties Panel

The Pattern Properties panel allows users to specify and modify the properties of any pattern in a report model.

You can specify up to five patterns at a time in a report model by increasing the number of Pattern Count in the Region Properties group box in the Pattern Properties panel.

Note: This option increases the number of patterns to capture lines within one particular data region.

You can learn more about how the Pattern Count works by clicking here.

Let’s discuss the options available in the Pattern Properties group box:

  • Case Sensitive Pattern Match

This option matches the data on a case-sensitive basis. For example, “Account” and “account” will be treated as two different patterns by Astera if this checkbox is enabled.

  • Apply Pattern to Line

This option is useful when the specified pattern does not capture the first line of the desired data region. Simply put, when there is some information above the pattern keyword then we increase Apply Pattern to Line from 0.

You can learn more about how the Apply Pattern to Line option works by clicking here.

  • Pattern is a Regular Expression

It directs Astera to read the specified pattern as a regular expression. A regular expression is a special text string used to describe a pattern.

You can learn how the Pattern is a Regular Expression option works by clicking here.

  • Floating Pattern

A floating field pertains to data points that appear in various locations throughout your report. The Floating Pattern option allows you to capture patterns within a report model even when the repeated phrases are misaligned vertically. Once the Floating Pattern option is selected, it will capture all the lines that match the specified pattern.

  • Float Fields

The Float Fields option will automatically appear once the Floating Pattern option is selected. The Float Fields option ensures that the line spacing also floats and is based on the line used to capture the first field. This is checked by default but can also be unchecked if you’d like the field position to be fixed.

You can learn more about the Floating Pattern and Float Fields here.

This concludes our discussion on the Pattern Properties panel in a Report Model.

Last updated

© Copyright 2023, Astera Software