Skip to main content

Pattern Clause Position Matching

For a number of different transform types, you can specify the limits at which any match is valid for a text string. In the diagram below, you can see how six different positional identifiers can be applied to pattern matching:

Note

Depending on the type of transform, some of these clauses are not available.

Positioning

PatternPositionClausesDiagram.png

Figure: Pattern Clause Positioning

after

Identifies pattern or string after which the match is evaluated.

Example transformation:

Transformation Name

Extract text or pattern

Parameter: Column

MySentence

Parameter: Option

On pattern

Parameter: After pattern

'eat '

Extracts:

pizza on Fridays with my friends."
from

Identifies pattern or string from which the match is evaluated. Any match includes thefromclause pattern or string.

Example transformation:

Transformation Name

Extract text or pattern

Parameter: Column

MySentence

Parameter: Option

Between two parameters

Parameter: After pattern

'eat '

Parameter: Include as part of match

true

Extracts:

eat pizza on Fridays with my friends."
before

Identifies pattern or string before which the match is evaluated.

Example transformation:

Transformation Name

Extract text or pattern

Parameter: Column

MySentence

Parameter: Option

On pattern

Parameter: Before pattern

'friends'

Extracts:

"I like to eat pizza on Fridays with my
to

Identifies pattern or string up to which the match is evaluated. Any match includes thetoclause pattern or string.

Example transformation:

Transformation Name

Extract text or pattern

Parameter: Column

MySentence

Parameter: Option

Between two patterns

Parameter: Before pattern

'friends'

Parameter: Include as part of match

true

Extracts:

"I like to eat pizza on Fridays with my friends
on

Identifies pattern or string in which the match may be found.

Example transformation:

Transformation Name

Extract text or pattern

Parameter: Column

MySentence

Parameter: Option

On pattern

Parameter: Match pattern

'Fridays'

Extracts:

Fridays
at

Identifies the index of starting (x) and ending (y) characters in the string to match. In the above example,at:2,6matches the stringlike.

Example transformation:

Transformation Name

Extract text or pattern

Parameter: Column

MySentence

Parameter: Option

Between two positions

Parameter: Positions

2,6

Extracts:

like

Pattern Parameter Interactions

The following table identifies the pattern parameters that can be matched with the parameter in the left column.

Note

The at parameter does not interact with any of the listed parameters.

Parameter

after

from

before

to

on

after

See Note 1.

No.

before or to

before or to

Yes. Can include before.

from

No.

See Note 1.

before or to

before or to

No.

before

after or from

after or from

See Note 1.

No.

Yes. Can include after.

to

after or from

after or from

No.

See Note 1.

No.

on

Yes. Can include before.

No.

Yes. Can include after.

No.

  • Note 1: If there is no other pattern parameter in the transform, the maximum number of matches per cell is 1. If there is a matching parameter, more matches per cell can be found.