This guide will help you learn how to find the records that contain a desired text string.

Contain Function Configuration

Please follow these steps:

1. Configure data sources and provide the mapping
   
   
   
   
2. Open an operation node (Filter or Validate)
3. Drag-and-drop the source field you want to check to the operation's work panel
4. Click on the String button (in right column)
5. Drag-and-drop the Contain function to the operation's work panel
6. Map the source filed with the Contain function
   
   
   
   
7. Double-click on the Contain icon
8. Fill in the necessary string
   
   
   
   
9. Click Ok
10. Close the Filtration window

Now you can preview the result or continue data integration.

See also

      Related Forum Topic

      Does Not Contain Function