Summary

This operator analyses text patterns in one cell. it searches in a string for one or more sub-strings. This operator can be used on any table with a text column.

Configuration

Input settings of existing table

Name

Value

Opt.

Description

Example

Column to analyze

System.String

-

Column which should be analyzed

col1

Settings

Name

Value

Opt.

Description

Example

Analyze

System.String

-

Analyze how often certain text pattern occurs.

pattern

Cyclical analysis?

System.Boolean

-

Cyclical means: End of text is checked with start of text.
Example: SSNN--FF is identical to FFSSNN--.

-

Separator

System.String

  • No delimiter
  • Colon
  • Semicolon
  • Dot
  • Vertical line (l)
  • Pound (#)
  • Star
  • Minus
  • Apostrophe
  • Blank

-

Necessary for cyclic analysis, since source text is being expanded, to check end with beginning.

Colon

Want to learn more?

Screenshots


Examples

Example: Fruits

Situation

In the text column A (fruit) should be analyzed where the fruits are going.

non cyclical test

Settings

Result

Project File

-

Example: Text

Situation

In the text column B (Layer designation) should the strings "NN", "FFSSNN" and "SS-FF" be found.

cyclical test

Settings

Result

Project File

-

Troubleshooting

Nothing known up to now.

Related topics