Problem to read a csv file.
A csv-file is a file of strings organized in rows - delimiter;"\n" and columns delimiter:";" (?)!
1) I would first get the ulong filesize=FileSize(..);
2) Now I would read the whole file into s a string sAll=FileReadString(..);
3) Now you have to split sAll into rows "\n" and than each row ";" into columns and now you have to convert each column-string into a value like FileReadInteger(..), or FileReadFloat(), or ...
I want read dates of a csv file using Filereadarray.
The file is a csv file with one column (of Excel) with the values 1 2 3 4 5 6 7 8 9. The program read a different value.
The file a excel file with one column with values 1 2 3 4 5 6 7 8 9IHDR Í Ÿßeà "6IDATxœí]Í®âÆÖÝHy„¤ó6Rç@É•23L¬VÄ”™‰”L˜!µZbÆW
̘¢«ˆ ‡Ù•¾{/p Z¼@’~¾úñOU¹ æ 0öt ÿ—Ë›r¹Vµ¿: €@\_ݺ ˆ§€g«v©>
þ®ŽüuÇ íÇ5³»p_û¼¬Úµ]/¨ÄùâŒE“õr8ØÑb
h¨†ó¦X$Û«'Ž4{²~Ú{¿xœñhj,k¥úª®kUf~³5\uz;h6èØvÜÁnöóü Ãæ7í¼=+ko³±ž»m
Xœ^³ãVÔt-Ê,o·÷· 4n]Æ[`? oÞI„÷ër°~cõزgûg•a9°úkÞ\U+&ì—d¥a‚µ»mo»™vKAwÕu Œ3Z5ˆó‘øÞ$?d¯9#ý²®å €ÄÝ|¹ï÷Æbj9“[”ð60+U÷e ¿ W‹[–¦ø qf4šÞПô¡T*ÑÞLÍí•ÐJ¶{ÍYê²ïÍgz] ^ ´.Ê'öG kÏx¥.H„·X“ ýâ,Õš´ÜY :7-â`OÂê Xë°oö:ïMR©>‰¬R=\O~Çõó|\ ýôôF>VÇë÷Ïž¶á:
Make up your mind; it's either a csv or it's a binay excel file that looks like this:Did you save as and set the file type? You cant read excel files.
Many thanks
The file that I want read is a csv file. This file was created by Excel and saved as csv (option of Excel).
If I open this file with any software of text (example notepad) I don't see any symbol (/n, ;). I see with an aspect very similar to excel.
If I put in the code
file_handle= FileOpen(InpFileName,FILE_READ|FILE_CSV);
I obtain an handle -1
But if I write
file_handle= FileOpen(InpFileName,FILE_READ|FILE_CSV);
I obtain a handle 1. In this case, I obtain values very different values that the files
I attach the file
file_handle= FileOpen(InpFileName,FILE_READ|FILE_CSV);
I obtain an handle -1
What is the error? find out why. What are Function return values ? How do I use them ? - MQL4 forum and Common Errors in MQL4 Programs and How to Avoid Them - MQL4 Articles
Many thanks for your help, but I don't find the solution.
I want resume all
When I compile I obtain 0 errors and 0 warnings.
When I run the code, I have put a Watch to some parameters to array (size and the array()).
Before, I said that when I put
file_handle= FileOpen(InpFileName,FILE_READ|FILE_CSV);
I obtain a value ofr -1. It's false, it's an error mine.
When I put this code, I obtain a size of array of 0, and don't read any value.
Instance when I put the code
file_handle= FileOpen(InpFileName,FILE_READ|FILE_BIN);
The same file I obtain a size different of zero and read values (differents to the file)
I attach the code and excel for understand better.
I am sure that it's a mine error, but I don't know
- Free trading apps
- Over 8,000 signals for copying
- Economic news for exploring financial markets
You agree to website policy and terms of use
I want read dates of a csv file using Filereadarray.
The problem is that the program read a values different of that csv file.
The file is a csv file with one column (of Excel) with the values 1 2 3 4 5 6 7 8 9. The program read a different value.
I cant use Fileopen with the flag FILE_CSV because I don't read the file (return value -1). If I use the flag FILE_BIN open the file, but read a different value.
I have read many articles but I havent' found nothing about this case.
I attach the code.
/
/+------------------------------------------------------------------+
//| alberto1.mq4 |
//| Copyright 2015, MetaQuotes Software Corp. |
//| https://www.mql5.com |
//+------------------------------------------------------------------+
#property copyright "Copyright 2015, MetaQuotes Software Corp."
#property link "https://www.mql5.com"
#property version "1.00"
#property strict
input string InpFileName="campo.csv";
int file_handle;
string filename1;
string filename2;
//+------------------------------------------------------------------+
//| Expert initialization function |
//+------------------------------------------------------------------+
int OnInit()
{
//---
//---
return(INIT_SUCCEEDED);
}
//+------------------------------------------------------------------+
//| Expert start function |
//+------------------------------------------------------------------+
int start()
{
int arr[];
//--- read all data from the file to the array
file_handle= FileOpen(InpFileName,FILE_READ|FILE_BIN);
FileReadArray(file_handle,arr);
//--- receive the array size
int size=ArraySize(arr);
//--- print data from the array
for(int i=0;i<size;i++)
Alert("Date = ",arr[i]);
//--- close the file
FileClose(file_handle);
The file a excel file with one column with values 1 2 3 4 5 6 7 8 9
Best regards.
Alberto