edgars.rworks:
You need to seek to the start of the next information you want to read, so once you have read the first row you need to SEEK relative to the current position, SEEK_CUR, the problem with this is knowing how long your strings are, if you know this then you can do it, if not the simplest way is to read the stings, once you have read all those between where you are and where you want to get to you can then read the correct string. Hi,
I have created CSV file that consists of such structure. I have about 10 000 rows with this type off data.
Semicola separetes each other column so that data would be readable.
What I want to achieve is to be able read that data and do some basic analysis. I am using this code
How can I read first row for each column and then move to next row. I understand it is about offset. But how can I do that, just insert in cycle that changes the offset from 1 to number_of_rows ? or there is other method?
Thanks :)
So you will need to read 5 times to get to the next date . . .
RaptorUK:
You need to seek to the start of the next information you want to read, so once you have read the first row you need to SEEK relative to the current position, SEEK_CUR, the problem with this is knowing how long your strings are, if you know this then you can do it, if not the simplest way is to read the stings, once you have read all those between where you are and where you want to get to you can then read the correct string.
So you will need to read 5 times to get to the next date . . .
You need to seek to the start of the next information you want to read, so once you have read the first row you need to SEEK relative to the current position, SEEK_CUR, the problem with this is knowing how long your strings are, if you know this then you can do it, if not the simplest way is to read the stings, once you have read all those between where you are and where you want to get to you can then read the correct string.
So you will need to read 5 times to get to the next date . . .
Strings consists of just 3 characters .
You are missing trading opportunities:
- Free trading apps
- Over 8,000 signals for copying
- Economic news for exploring financial markets
Registration
Log in
You agree to website policy and terms of use
If you do not have an account, please register
Hi,
I have created CSV file that consists of such structure. I have about 10 000 rows with this type off data.
datetime;string1;string2;string3;string4;string5;
Semicola separetes each other column so that data would be readable.
What I want to achieve is to be able read that data and do some basic analysis. I am using this code
How can I read first row for each column and then move to next row. I understand it is about offset. But how can I do that, just insert in cycle that changes the offset from 1 to number_of_rows ? or there is other method?
Thanks :)