Create your first automation in just a few minutes.Try Studio Web →
by GERT
0
Activity
<100
Summary
Summary
This custom activities package is specifically designed to facilitate advanced filtering between lists.
Overview
Overview
This custom activities package contains two main activities, which help with various use cases, including filtering out forbidden words from a list of strings.
The 'Advance Filter' activity is specifically designed to handle scenarios where there is a large list of items, potentially imported from an Excel spreadsheet, and there is a need to identify or remove specific items based on certain criteria. For instance, in a situation where a dataset contains millions of rows with diverse text information, and there is a requirement to check for the presence of censored words, a prepared list of such words can be effectively applied using this activity. The filtering process is executed with speed, providing results in a matter of seconds.
This version includes the filter itself where it accepts as input 2 Lists of Strings and the Output is a List of String. Also, if the information is in a DataTable Column, it includes an activity that converts a DataTable column to a List of String.
Features
Features
The benefit of using this package is mostly speed. Unlike a simple loop-based approach, this package utilizes an efficient HashSet to accelerate the filtering process. This enables the activity to quickly scan through large lists of items, and identify or remove specific items based on predefined criteria, such as censored words.
Additional Information
Additional Information
Dependencies
None
Code Language
C#, Visual Basic
Runtime
Windows (.Net 5.0 or higher)
License & Privacy
Apache
Privacy Terms
Technical
Version
1.0.0Updated
April 21, 2023Works with
Studio: 22.10+
Certification
Gold Certified
Support
Phone: +355693147062
Email: support@gertn.com
Link: https://gertn.com/Mon-Fri 9 AM to 6 PM (CET; UTC+01:00); Response time: 1 day; Resolution time: 10 days.