Performing various CSV File Operations

Transform, Delete, Augment, Add, Read the content of CSV files easily all based on simple yet powerful editing commands.

Top Benefits

  • Easily manipulate complex CSV files without having to worry about complex logic

This bot performs various actions on a CSV file – 1. Add Column After 2. Add Column Before 3. Append text to column if Column Matches Regex Pattern 4. Delete Column 5. Delete line if cell matches RegEx 6. Enforce column order 7. Get cell content 8. Get column Index 9. Get column names 10. Get Line Content 11. Get Number of columns 12. Get Number of Lines 13. Keep Lines if Cell matches RegEx 14. Set Cell Values Based on Line Range 15. Swap 2 columns

20+ Commands available to modify and read CSV files in a very easy way

Key Use Case: Mass Processing and Editing of CSV FilesMass Processing and Editing of CSV Files

Get Bot

Free

Bot Security Program
Level 1
Applications
Business Process
Category
Downloads
526
Vendor
Automation Type
Bot
Last Updated
July 24, 2020
First Published
October 26, 2018
Support

See the Bot in Action

PREV NEXT

Setup Process

Install

Download the Bot and follow the instructions to install it in your AAE Control Room.

Configure

Open the Bot to configure your username and other settings the Bot will need (see the Installation Guide or ReadMe for details.)

Run

That's it - now the Bot is ready to get going!

Requirements and Inputs

  • AAE 10.7 sp2
  • Inputs: Path to Input CSV File