delete first 100 row in csv file

[ma7amadk]

Hello,

I am trying to modify an indicator that create csv file for 28 symbol spreads every tick.

But after some time that file got big size (1,000,000 row after 24 hours!)

How to delete the first 100 row when total rows reach 1000 row for example?

Thanks,,

int handle = FileOpen(filename,FILE_READ|FILE_WRITE|FILE_CSV);
   if (handle>1)
   { 
      FileWrite(handle, "Broker","Symbol","Date","Time","Spread","Bid","Ask");
      FileSeek(handle, 0, SEEK_END); // go to end of file
      FileWrite(handle, AUDCAD);
      FileWrite(handle, AUDCHF);
      FileWrite(handle, AUDJPY);
      FileWrite(handle, AUDNZD);
      FileWrite(handle, AUDUSD);
      FileWrite(handle, CADCHF);
      FileWrite(handle, CADJPY);
      FileWrite(handle, CHFJPY);
      FileWrite(handle, EURAUD);
      FileWrite(handle, EURCAD);
      FileWrite(handle, EURCHF);
      FileWrite(handle, EURGBP);
      FileWrite(handle, EURJPY);
      FileWrite(handle, EURNZD);
      FileWrite(handle, EURUSD);
      FileWrite(handle, GBPAUD);
      FileWrite(handle, GBPCAD);
      FileWrite(handle, GBPCHF);
      FileWrite(handle, GBPJPY);
      FileWrite(handle, GBPNZD);
      FileWrite(handle, GBPUSD);
      FileWrite(handle, NZDCAD);
      FileWrite(handle, NZDCHF);
      FileWrite(handle, NZDJPY);
      FileWrite(handle, NZDUSD);
      FileWrite(handle, USDCAD);
      FileWrite(handle, USDCHF);
      FileWrite(handle, USDJPY);
      FileClose(handle);
   }

[Jack Thomas]

You should use a real database.

[ma7amadk]

Jack Thomas:
You should use a real database.

any references or an example?

[Jack Thomas]

Use the search function on mql5.com and you'll find quite a bit of information on the subject.

OR....

https://www.mql5.com/en/job/new?prefered=smarterai