584e3080-9cdb-42b1-916d-71c5c8cfe169.jpg

RPA Developer

d1c40696-3337-4fd9-a849-e6ad501bc5c3.png

**Move Data**: To begin the process, use the "Apply Filter" activity with the following criteria: "Equal", "Not Equal", "Like", "Not Like", "Starts With". The items criteria are specified as Array of Strings.

If there are visible rows use the "Move Visible Rows" activity: The main arguments are the Source and Destination Sheet and the set of Columns to be moved: "All Columns", "List of Columns" (to be specified as Array of Strings), "Auto Match Column Names" (it will only 

extract the columns with the same name as found in the destination sheet).

To finish the cycle, use the "Delete Visible Rows" activity to delete the moved rows from the Source Sheet and proceed with the next filter and extraction.

  

Other Activities include:

*   **Read & Write Cell** (Use Cell and Column Number instead of Range, there is also an ecrypt option to protect sensitive data)
*   **Freeze Pane**
*   **AutoFit Columns**
*   **Wrap Text**
*   **Delete Sheet**
*   **Delete Sheet All Content**
*   **Delete Sheet Rows** (All Rows Below header row)
*   **Get All Sheets** (Populate data into an array)

Easy interactiong with Excel. Focused on filtering and then moving visible rows among sheets (in the same or separate excel file). Easy to use interface for speed and typing errors prevention.

**Extract text based on Anchor Text relative position to target text:**

*   Extract All Lines Below Anchor Words
*   Extract Text Above Anchor Words
*   Extract Text Below Anchor Words
*   Extract Text Between Two Anchor Words
*   Extract Text Until Blank Line
*   Extract Text Until White Space
*   Extract Text Until Next Letter

  

**Array Activties**

  

Find Items in Array and return matches in array item using LINQ

  

Find Array Items

Match Item in Array

  

**Split Activities**

  

Split Text By Blank Lines

Split Text New Lines

Split Text Uneven Blank Spaces

  

**Edit Text**

  

Remove Empty Wrods

Remove Words

Replace Words

  

**Text Encryption**

  

Encrypt and Decrypt pieces of text, four C# encryption algorithms are available in the package

  

**Other Activities**

  

Count Words in Text

  

**Text Analysis**

  

Language Detection (Config File in the Project Demo in Resource Link)

Sentiment Analysis

Extract data from text files using Regex without the need to write those complex Regex expressions! Run text analysis using Language Detection and Sentiment Analysis

About me