View Source

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

Enterprise Release 5.1 > Pattern Clause Position Matching > PatternPositionClausesDiagram.png

Pattern Clause Positioning

Position Parameter Description Example

after

Identifies pattern or string after which the match is evaluated.

extract col:MySentence after:'eat '

Extracts: pizza on Fridays with my friends."

from

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

extract col:MySentence from:'eat '

Extracts: eat pizza on Fridays with my friends."

before

Identifies pattern or string before which the match is evaluated.

extract col:MySentence before:'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 the to clause pattern or string.

extract col:MySentence to:'friends'

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

on

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

extract col:MySentence on:'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,6 matches the string like.

extract col:MySentence at: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.