tienxviet

I'm trying to sort and calculate a huge text file.
I'd like calculate the daily flow by month/year first.
and then also for Annual along with the station code.
I think you'd have to skip the first 17 lines to begin reading the data.

For Ex:
Station Code Month Flow(cfs) Annual Flow(cfs)
02429900 June 1973 ----- 1973 ------
02429900 July 1973 ----- 1972 ------
etc.

I've attached the text file.
But here's some of the file. (Disregard the A and Ae)

USGS 02429900 1973-06-01 21 A
USGS 02429900 1973-06-02 19 A
USGS 02429900 1973-06-03 17 A
USGS 02429900 1973-06-04 16 A
USGS 02429900 1973-06-05 15 A
USGS 02429900 1973-06-06 30 A
USGS 02429900 1973-06-07 26 A

Anything will be of help.
Thanks

TheRealTinTin

Hi tienxviet and welcome to XVBT.

The text file you supplied only had little over 11,000 records so not big. Do you have MS Excel? The easiest method would be to open the text file in that and use the tab delimited option, that will pull through into columns and then you can use the normal sort functionality within Excel. Or are you looking to automate the process?

If the latter, you could record a macro while importing the data and then you will be able to use that macro each time (provided the file name is the same each time).

You could of course go further and add in your own code that allows you to choose a file and where you want it imported to etc. but given the size of the data and the time it takes to import it manually (no more than 10 secs), unless this was a repeating process throughout the day, I don't see any advantage in doing it this way. Of course, the choice lies completely with you however.