This guide will help you learn how to filter out the strings that contain invalid IP address formats. The Is IP Valid function is based on validation with Regular Expressions.

Configuration

To start validating IP address formats,

1. Configure data sources and provide the mapping
   
   
   
   In this example, we will use the following table as a source:
   
   
   
   
2. Open the Filter (or Validate) node
3. Click on the String section to find the Is IP Valid icon
4. Drag-and-drop it to the Filtration's work panel
   
   
   
   
5. As well, drag-and-drop the field that contain values for validation
6. Map the nodes according to the picture below
   
   
   
   
7. Press Ok and close the Filtration window

Now the output table will contain only those records where the Column field value is entered in an IP address format.

Preview

To preview the results, right-click on the output node and select "Preview Results". The following window will pop up:

           

Close the window and continue data integration.

See also

          Is URL Function