Hello experts and forum users....
As of current i used manual method to correct the database i use for amibroker. the data that i get in NEST saved as csv file is purposely hammered like
Does any one knows how to automatically remove all the lines that has
"0.0000,0.0000,0.0000, " data ..OR
i want some code/software that can remove entire line if data is 0.0000,0.0000,0.0000, ......
thx
i use notepad and use find function to manually delete 0.0000,0.0000,0.0000 but it;s tiring work if u miss a day then everyday same process..
I wish there was some software or code that could just filter output the errortic data in red .. i am sure c program can be made or VB code idk
Thanks for read and replies
Solution given by Master KelvinHand and it works
I made a little change in extension it works Thanks again mate ^^^
1. Save the following code into "test123.js" in a folder
2. Save your datafile in post #1 as mydata.csv the same folder. (Try out first)
3. run the jscript in that folder
4. The code will produce mydataready.csv where all those errors should be filter.
5. mydataready.csv is the filtered file without lag data
Note: do not create in root dir eg. c:\
As of current i used manual method to correct the database i use for amibroker. the data that i get in NEST saved as csv file is purposely hammered like
Does any one knows how to automatically remove all the lines that has
"0.0000,0.0000,0.0000, " data ..OR
i want some code/software that can remove entire line if data is 0.0000,0.0000,0.0000, ......
thx
i use notepad and use find function to manually delete 0.0000,0.0000,0.0000 but it;s tiring work if u miss a day then everyday same process..
I wish there was some software or code that could just filter output the errortic data in red .. i am sure c program can be made or VB code idk
Thanks for read and replies
Solution given by Master KelvinHand and it works
I made a little change in extension it works Thanks again mate ^^^
1. Save the following code into "test123.js" in a folder
2. Save your datafile in post #1 as mydata.csv the same folder. (Try out first)
3. run the jscript in that folder
4. The code will produce mydataready.csv where all those errors should be filter.
5. mydataready.csv is the filtered file without lag data
Note: do not create in root dir eg. c:\
Code:
filename ="mydata";
var iFile = filename+".csv";
var oFile = filename+"ready.csv";
var fso, fi, fo, r;
var ForReading = 1;
var xO, xH, xL;
/* ... and file system object */
fso = new ActiveXObject( "Scripting.FileSystemObject" );
if (fso.FileExists(oFile)) fso.DeleteFile(oFile);
/* open ASCII file */
fi = fso.OpenTextFile(iFile, ForReading);
fo= fso.CreateTextFile(oFile, false);
/* skip first line which contains format definition */
r = fi.ReadLine();
fo.WriteLine(r);
/* read the file line by line */
var cnt =0;
while ( !fi.AtEndOfStream )
{
r = fi.ReadLine();
/* split the lines using coma as a separator */
fields = r.split(",");
xO = parseFloat( fields[2]);
xH = parseFloat( fields[3]);
xL = parseFloat( fields[4]);
if (xO>0.0 || xH>0 || xL>0)
{
fo.WriteLine(r);
}
else
{
cnt++;
}
}
/* refresh ticker list and windows */
/* notify the user */
WScript.Echo( "Finished! Error Count = " + cnt );
Last edited:
