Latest Uploads
Damn Bounces

AndyH

Wonder Wom ... ting thing

rychan

SoCoder 1 ... 0 Patreon

Jayenkai

Vagina

Jayenkai

You Were Defeated

rychan

IFS Viewer 3

Andy_A

Forum Home

File Manipulation

UserMessage
Posted : Monday, 06 December 2010, 03:34 | Permalink
mole


WW Entries : 7
Hi,

Long time no see. I still lurk occasionally but I haven't posted for a while and I certianly haven't coded for a while. Hence, I am rusty.

Therein lies my dilemna: I have a task I wish to complete, and I believe that a little Blitz program will make this easier.... If only I could properly remember how to program, that is.

Anyway, I'll start off with my first problem. I am trying to read a column of data from a text file. The first line of the column is a text string and the lines beneath are floats. I am trying to commit this data to 2 arrays: 'FirmName$(a)' for the string, and all of the rest of the floats into 'DataSet1#(b)'.

Here if my code so far. Unfortunately, I have got stuck quite early on in the sense that my debug reporting suggests that it can't see any data in the file...

-->

Any help, links, tips would be super cool.

I will no doubt return quickly after this problem is solved with another problem, as my program develops in size and sophistication.

Thanks in advance!

Homepage : www.squigglesoft.co.nr
Posted : Monday, 06 December 2010, 03:55 | Permalink
Jayenkai


WW Entries : 104
Is the "Float" stored AS a float, or is it a line of text?
(as in, if you open the .dat in notepad, is it readable, or gobbledegook)

If so, ReadTxt$=ReadLine(CorrelData): Read1#=float(ReadTxt$)

-----
"Load, Next List!"
Homepage : http://AGameAWeek.com
Posted : Monday, 06 December 2010, 08:11 | Permalink
mole


WW Entries : 7
The data in the file is readable. I will upload it for reference.

I managed get the program to output the data as I expect it to; the data is being stored as I want.

However, that means we now have the next step. By the end, the file will have anything up to 100 columns of data. I need to be able to store all that data in arrays (I can't quite remember but can you have arrays such as 'Dim ArrayName(5,5)'?).

When all the data is stored, I hope to be able to calculate the correlation coefficients between each of the columns of data. That is something I will consider more deeply when I get to it; at the moment I am just trying to get all the data into array ready for processing.

What I can't think of how to do, is the parse/read the file of data and get each chunk of data into its appropriate place in the array. that is where I need help. I never was good at file manipulation

Here is the latest code:
-->

Correlation Data File
Note that I had to change the file extension to the less cool .txt in order to upload it.
Homepage : www.squigglesoft.co.nr
Posted : Monday, 06 December 2010, 17:57 | Permalink
Andy_A


Here's what it sounds like you want.

-->
Posted : Wednesday, 08 December 2010, 06:19 | Permalink
mole


WW Entries : 7
I have spend the last day and a half working on your code, Andy, and fine tuning it/modifying it to my needs. Your structure has proved invaluable in allowing me to progress, so a big thanks for that.

The latest I have done so far is make it super easy to change the number of firms in the data file without making the program have a wobbly, introduce a correlation coefficient calculator function, and implement it in a manner such that it calculates the coefficients between all the firms in the data file.

Calculating the correlation coefficient between the data from the file is exactly what I wanted - and it works! This makes me happy.

So now that the program is robust enough for my needs, all I need to do now is get data on another 95 firms or so!!

I should be able to make any minor modifications to the program if the need arises, but I'll be back if there is something that stumps me

Many thanks for your help, Jay and Andy. It is most appreciated.
Homepage : www.squigglesoft.co.nr
Posted : Wednesday, 08 December 2010, 06:35 | Permalink
Jayenkai


WW Entries : 104
Sorry, I completely forget to get back to this topic! Glad you sorta sorted it!

-----
"Load, Next List!"
Homepage : http://AGameAWeek.com
Posted : Wednesday, 08 December 2010, 08:44 | Permalink
Andy_A


Glad it all worked out for you.

Getting the data into arrays was the toughest part (and it wasn't all that hard).
-=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- (c) WidthPadding Industries 1987 726|0 -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=-
Latest Posts
WW - #244 - The Ten Challenge
Jayenkai Tue 03:55
RIP : Gene Wilder
steve_ancell Tue 00:59
Blitz in the Steam
Jayenkai Mon 22:30
SoTweaking
Jayenkai Mon 08:00
Flip Out!
Jayenkai Mon 04:02
BBC Bringing Back Comedies
Jayenkai Sun 14:42
Backspace is no longer Back in Chrome
GfK Sun 14:21
AGameAWeek : 2016 - Part Two
Jayenkai Sun 14:07
Red Dwarf XI and XII
rockford Sun 02:32
VirginMedia SpeedBoost - Finally..
Jayenkai Fri 07:29
More

Latest Items
Blog : Monkey-X Box2D: Learning from my perspective... Hopefully!
steve_ancell Sun 14:49
Snippet : JNKrunch v1.0
spinal Sun 12:02
Snippet : Dungeon/Cave Generator - Simple
Pakz Wed 15:05
Snippet : Platform Sprite Generator
Jayenkai Tue 15:22
Snippet : Code Creates Crates
HoboBen Tue 07:02
Snippet : Texture - Leafy camouflage
HoboBen Tue 07:00
Snippet : Texture - Stone 3
Pakz Mon 09:55
Snippet : Texture - Stone 2
Pakz Mon 09:50
Snippet : Texture - Stone 1
Pakz Mon 09:46
Snippet : Texture - Cloudy Patterns
Pakz Mon 08:57
Showcase : Mining Map AI Demo
steve_ancell Wed 08:00
Showcase : Grey Lined Backgrounds
HoboBen Mon 04:17
Showcase : CAVE
Jayenkai Sun 07:20
Showcase : I Shall Be Queen!
rychan Fri 06:41
Snippet : Thousands of 3D Cubes
Pakz Fri 02:49
More

Who's Online
Jayenkai
Tue, at 06:45
GfK
Tue, at 05:23
steve_ancell
Tue, at 05:19
rychan
Tue, at 02:59
shroom_monk
Tue, at 02:49
Pakz
Tue, at 01:05
spinal
Mon, at 22:29
Dabz
Mon, at 22:29
rockford
Mon, at 21:27
HoboBen
Mon, at 20:08
Link to this page
Site : Jayenkai 2006-Infinity | MudChat's origins, BBCode's former life, Image Scaler.