Guidance
指路人
g.yi.org
Guidance Forums / Rapid-Q Basic / CSV-files. (Comma Separated Value).

Register 
新用户注册
Search 搜索
首页 
Home Home
Software
Upload

  
Forum List • Thread List • Reply • Refresh • New Topic • Search • Previous • Next First 1 Last
Message1. CSV-files. (Comma Separated Value).
#5079
Posted by: 2004-09-15 02:59:31
I need some help to make a program to handle CSV-files. (Comma Separated Value).

I have an input file with data like this KGGN.TXT:
19970130,13.05,13.38,13.00,13.05,1950160,0
19970131,12.77,13.15,12.76,12.77,3083100,0
19970203,12.77,13.15,12.74,12.77,2114604,0
19970204,12.88,12.96,12.81,12.88,1895578,0
19970205,13.05,13.17,12.92,13.05,1785548,0
…1000 lines (records)

The program has to read this data, make a calculation (like multiplying) of the pricedata, and write the entire line, with the recalculated pricedate back to another file like KGGNmod.TXT.

I looked at the internet, but I couldn’t find any example.
Can somebody help me with this? Any suggestion is welcome.

Thanks, Hans
Message2. Re: CSV-files. (Comma Separated Value).
#5088
Posted by: 2004-09-15 22:28:04
In addition to the answer at ezBoard;

  td = (a-ld)*10^DD + .5
  d$ = mid$(str$(d),2,DD)

would be a way to round the value for the formatting. The problem of values exceeding the number of decimals remains, obviously. Another problem is negative values.

The way to use the routine would be;

 a = somevalueorother : FD = 2 : DD = 2 : FmtDt

for every value.
Forum List • Thread List • Reply • Refresh • New Topic • Search • Previous • Next First 1 Last
掌柜推荐
 
 
 
 
 
 
 
 
 
 
 
 
© Mon 2017-9-25  Guidance Laboratory Inc.
Email:webmaster1g.yi.org Hits:0