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

Configuration

To start validating URL 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 URL 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 valid URL 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 IP Valid Function