column selection and reordering
Mostly data files are from the beginning asci textfiles.
the data are structured on one row for each item
with several columns of data.
A common ued dataseparatro are (,)
Item,Prisevalueopen,PrisevalueClosevalue,PriseValueHigest,volume,Date,FundamentalData01Ear
ningPerEmployee,,,,,,,,,,,,(60columns or more,,)
MSFT,45.35,45.63,46.56,2000,20021011,3453,23423,56,392,,,3453,
I want to use
the name column=01
the prise column=02 to 04
the volum column=05
like this
output column order: 01,04,03,02,05,06,
and
output:01,62,,,,, (Earnings per employee data)
output:01,45,,,,, (Institutiona owner of MSFT)
This means 3 files out with diffrent column order.
This operation is a type ot converting of data.
Now I aslo have textfiles with diffrent rows I whant to make this column output from
Sutch a group of data are software companies
the textfile are called
Nasdaq-SoftwareCompaniesTickerName.
I therefor want the texteditor to read this selected
group of rows with the column 1 used to specifies
the ticker names.
Here are 3 interesting stocks from a group text file
called Nasdaq-Portfolio01.txt
MSFT
INTC
DELL
By selecting this I ripp out data for this 3 stocks
in a colum order I want.
Next is to open a caclylation txt file.
it is called
INDEX Nasdaq-Portfolio01.txt
Make index by adding all numeric values in row: 02 Yes
Divide it with the number of items in column: 01 Yes
Use column as prefix to output filename: NO
Use column as suffix to output filename: 06 Yes
Use input filename of Index to output filename: Yes
Use input filename of Index as ticker name: Yes
Use column 06 as column 06 in output file Yes
Write calculated value to column 04,03,02, Yes
This wil make a file called
INDEX Nasdaq-Portfolio01,20021011.txt
with
INDEX Nasdaq-Portfolio01,Index01,Index02,Index03,20021011
Hope You understand
If the texteditor also coluld
1. Read all input data files to memmory
say 360 dayfiels for a year with each file having
500.000 rows and 65 columns and calcylate on them,
or chart then we would have a progam 1000 times faster
than enything els ever made.
ALL CALCYLATION OR CHARTING OF DATA WOULD BE ON THE FLY FROM MEMMORY.
PLEASE MAKE A KILLER APPLICATION OR FILEMANGER
column selection and reordering - column selection and reordering
Moderators: fgagnon, nikos, Site Mods