Quick and simple CSV analyzer?

[marko_rakar]

hi

(sorry if this is in wrong place)

I have a project wich comes with literally hundreds of tables in form of various CSV files.

Is there some utility which can go through selected files and give me basic stats (number of rows/fields, min/max/avg values)?

Something quick and dirty, nothing fancy just so I get overview what is inside.

thanks

[MarcoWedel]

Hi,

maybe you could use some QlikView application to analyze your files like this:

tabCSVFiles:
CrossTable (Field, Value, 2)
LOAD FileName() as File,
    RecNo() as RecNo,
    *
FROM [QlikCommunity_Thread_270028_*.csv] (txt, utf8, embedded labels, delimiter is ',', msq);

(you could limit the loaded rows e.g. by appending "Where RecNo()<1000" to the load)

hope this helps

regards

Marco