I am given a number of very large csv files. A representative line from these files is
This sample contains 4 values, delimited by commas:
1. a date string "4/8/2013"
2. a time string "12:54:55.242500"
3. a data value, 8.986848E-3
4. a data value, -1.775244E-2
And it goes on, but this is enough to illustrate the problem. How to read this data? Note that the text items are not delimited by quotes; also the numerical values are expressed in exponential format but with different field widths, and in general they might be in F fields again of varying widths. Ideally I would use a list-directed (*) format to get the numerical values, but my effort stumbles and results in nonsensical results. It is not necessary that I actually read the first two character values. But how can I skip them and still use (*) format?
Data files of this nature are easily read by Excel, for example, and I am hard-pressed to convince others that Fortran is appropriate for this sort of application. Can somebody help me? (The files typically contain 24 values per line, and 90,000 lines, and I have to read hundreds of them and process the data they contain. Hence I want something more powerful than Excel).