There is a special type of spreadsheet known as a CSV. This is short for Comma Separated Values, which is a fancy way of calling a row that has values delimited by commas.
An example of such a row is the following:
| ID | Title |
| 1 | Don't be Horrid Henry |
| 2 | Horrid Henry and the Fangmangler |
It really isn't much to look at visually. It actually appears as one clump of text, which makes reading it rather hard to do. However, in many systems that integrate with other third-party systems that do not have Microsoft Excel installed, CSV is a good alternative for storing tabular data.
Blue Prism has a couple of utilities that make it really easy to work with CSV files. They are stored in the following library files:
- Utility — Strings library
- Utility — File Management
We will try out the examples in the Utility...