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 Files
See the Bot in Action
Download the Bot and follow the instructions to install it in your AAE Control Room.
Open the Bot to configure your username and other settings the Bot will need (see the Installation Guide or ReadMe for details.)
That's it - now the Bot is ready to get going!
Requirements and Inputs
- AAE 10.7 sp2
Inputs: Path to Input CSV File