Saving data to CSV files

CSV (Comma Separated Values) files are plain text files used to store tabular data, like Excel files or database tables, although in a much more limited way. Each line of the file stores a record (row) and each value (column) is separated by a comma character. Sometimes a tab, a semicolon or other character is used as separator. For example, a CSV file contains the following data:

02/01/2013;22.43;1.1
02/02/2013;21.54;1.2
02/03/2013;19.43;1.0
02/04/2013;18.56;1.1
02/05/2013;19.21;1.1
02/06/2013;19.12;1.1
02/07/2013;20.56;1.0
02/08/2013;21.65;0.9
02/09/2013;22.54;1.0
02/10/2013;23.12;1.1
02/11/2013;23.87;1.0
02/12/2013;20.32;1.0

read more …

How to arrange separately captured text values into one

Let’s say we have an email containing the following line:

date: 04-06-2004

But what we need is the date backwards (2004-06-04) and insert this text value in an Excel file. First we have to set up an email parser item to capture the day, month and year separately from the incoming emails. We have to use the regular expression: read more …