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

Betroffene Tabellenbereiche

Column to analyze

[input] Text-column which should be analyzed

Settings

Analyze

[Input] Analyze how often a given String appears in the whole text. You can search multiple strings, for every string there will be a column in the result table

Cyclical test?
[Input]Should the end of the text be analyzed together with the start of the text
e.g:
SSNN--FF is with a cyclical test the same as FFSSNN–.

Separator
[Input] is only required for cyclical test.
Choose: no separator, Colon, dot, vertical line (|), diamond (#), star, minus, single point, space

Want to learn more?

Settings

Analyzes text pattern within a cell

Columns of input table

Parameter

Screenshot

Examples

Example 1:

Start Situation

  • in the text column A (fruit) should be analyzed where the fruits are going
  • non cyclical test


Settings and Result

  • Settings used:
  • Result

Example 2:

Start Situation

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


Settings and Result

      • Folgende Einstellungen sind in der Operation vorzunehmen:
  • Dies ergibt:



Troubleshooting

Nothing known up to now

Related topics

  • ...