how to display data from .csv file?

[lgnihlman]

I need to display data from a .csv file but I don't know how to do it.

This is an example of the file, each line ends with CRLF.

2010-01-05 10:46;0;0;0;1;0;0;0;0;0

2010-01-05 11:42;0;1;0;0;0;0;0;0;0

2010-01-05 12:14;0;0;0;0;1;0;0;0;0

The goal is to read the data and display it in a table with automatic summation for each column.

Does someone have any ideas on this?

(I'm not a programmer)

[playlet]

---

Edited August 18, 2016 by playlet

[llewxam]

I need to display data from a .csv file but I don't know how to do it.

This is an example of the file, each line ends with CRLF.

2010-01-05 10:46;0;0;0;1;0;0;0;0;0

2010-01-05 11:42;0;1;0;0;0;0;0;0;0

2010-01-05 12:14;0;0;0;0;1;0;0;0;0

The goal is to read the data and display it in a table with automatic summation for each column.

Does someone have any ideas on this?

(I'm not a programmer)

How about do something like:

$break=StringSplit($line,";")

Of course, $line is to represent each line of the file, which you could get with FileReadLine. Anyway, StringSplit will break up a line according to the delimiter, in this case using ; makes sense. You will wind up with $break[0] telling you how many items there are, in your examples there will be 10. The first result ( $break[1] ) will be "2010-01-05 10:46" and you could break that up with StringMid or another StringSplit with a delimiter of " " if you would prefer, but I would use StringMid. I never used StringSplit to split a StringSplit result, syntax would be ugly!!!

Hopefully that helps.

Ian

[Stilgar]

You can use this function:

http://thorsten-willert.de/Themen/AutoIt/_CSV2Array.au3

Example:

#include <_CSV2Array.au3>
#include <Array.au3>

$aArray = _CSV2Array("c:\\file.csv")
_ArrayDisplay($aArray)

[lgnihlman]

You can use this function:

http://thorsten-willert.de/Themen/AutoIt/_CSV2Array.au3

Example:

#include <_CSV2Array.au3>
#include <Array.au3>

$aArray = _CSV2Array("c:\\file.csv")
_ArrayDisplay($aArray)

Thanks everyone !

The _ArrayDisplay func. will do the job for me.