Text: Find words that contain text

Use this action to search a block of text for words that start with, end with, contain, or do not contain a supplied search value. All search results are stored in a data table that includes the match and the match’s position.

This action can be used to find exact matches, like searching a body of text for a specific Employee ID number, or for more complicated searches, different Search types are available to help find what you’re looking for.

How to configure this action

Use the Search type and Search value fields to create complex searches. The search value is the word or phrase to search the text for, the search type is how the text is searched.

Example of how to search for keywords

Here are two examples of how search types and values are used together to find text. The examples use the following text for the Text to search.

From this date forward, all case specific information is required to inherit agreed upon terms and rights. For questions regarding these terms, contact the holding office between the hours of 2PM and 7PM. No case information is available outside of the municipality heretofore defined. See the GDPR clause below for details on privacy standards. GDPRcompliance exclusions apply.

Use search type CONTAINS to find words that contain a phrase

This example finds any reference to GDPR within the Text to search. Use the CONTAINS type to find a phrase, even if it’s inside of another word, or if there’s a typo.

  1. Enter Search type: CONTAINS and Search value: GDPR
  2. This will search the Text to Search content for the word GDPR, even if it is within another word.
  3. Two results are returned, including the position in the text. GDPR was identified twice in the last two sentences, “See the GDPR clause below for details on privacy standards. GDPRcompliance exclusions apply.”
    • An EXACT match would have only found the first GDPR instance, since there was a typo and the second instance was missing a space.

Use search type ENDS-WITH to find phrases with similar endings

This example searches the Test to search for any reference to PM, where PM is at the end of the phrase. Use the ENDS-WITH type to parse text for any words that end with the search value.

  1. Enter Search type: ENDS-WITH and Search value: PM
  2. This will search the Text to Search content for the word PM, but only if it is at the end of a word.
  3. Two result are returned, including the position in the text. PM was identified twice in the second sentence, “For questions regarding these terms, contact the holding office between the hours of 2PM and 7PM.”

Fields for this action

    • A block of text to search for matching words or field reference.
  • Output field name

    • The name of the data table in which the results should be saved.
  • Search type

    • Leave blank or enter EXACT - exactly match with the search value.
      • ANY - has any of these characters.
      • STARTS-WITH - starts with these characters, start of word, new line
      • ENDS-WITH - ends with these characters, end of word, end of line
      • CONTAINS contains these characters
      • NOT-CONTAIN - doesn’t contain these characters
  • Search value

    • Enter the text to be used or searched for
    • Example: Use .com with the ENDS-WITH search type to search for a text, like a URL, that ends in .com
  • Case sensitive

    • Enter TRUE to make your search case sensitive. Leave blank or enter FALSE to make your search case insensitive.

What will this output?

This action will output the matched results in a data table. The field name for the data table will be the output field name defined during configuration.

Output fields for this action

  • Data table

    • This field provides the ID for a Data Table where the results are stored. The table will have 2 columns:

    • Matching Text Position
      The text that matched the search value. The position of the matching text in the text body using a #,# syntax where the first value is the row #, and the second is the character # in the row.
    • Each row of the table is another instance of matched text and the text’s position.
  • Number of Matches Found

    • The number of matches found.

Sorry about that. What was the most unhelpful part?









Thanks for your feedback

We update the Help Center daily, so expect changes soon.

Link Copied

Paste this URL anywhere to link straight to the section.

Need more help?

If you're signed in to Catalytic Community, you can ask other users a question. You'll be redirected to Community where you can add more info.