Post by debluzz on Mar 30, 2018 12:18:37 GMT -5
(this is what I need)
BX11=,bx11
BX12=,bk12
BX13=,bk13
BX14=,bk14
BX15=,bk15
BX16=,bk16
BK=,bk11
BK=,bk12
BK=,bk13
BK=,bk14
BK=,bk15
BK=,bk16
TRN11=trn11
TRN12=trn12
TRN13=trn13
TRN13=trn14
TRN14=trn15
TRN16=trn16
INS11=ins11
INS12=ins12
INS13=ins13
INS14=ins14
INS15=ins15
INS16=ins16
STRCH11=strch11
STRCH12=strch12
STRCH13=strch13
STRCH14=strch14
STRCH15=strch15
STRCH16=strch16
INS11=ins11
INS12=ins12
INS13=ins13
INS14=ins14
INS15=ins15
INS16=ins16
FIN11=finish11
FIN12=finish12
FIN13=finish13
FIN14=finish14
FIN15=finish15
FIN16=finish16
lngs11=lngs11
lngs12=lngs12
lngs13=lngs13
lngs14=lngs14
lngs15=lngs15
lngs16=lngs16
ART11=art11
ART12=art12
ART13=art13
ART14=art14
ART15=art15
ART16=art16
GRAD11=grad11
GRAD12=grad12
GRAD13=grad13
GRAD14=grad14
GRAD15=grad15
GRAD16=grad16
(this is what I have)
[/p][p]open "lines1.txt" for output as #1
'dim the results array and use meaningfull names to
'index the array
dim results(50,10)
box=1
break=2
turn=3
strch=4
finish=5
lngs=6
art=7
grad=8
close#1
open "lines1.dat" for input as #1
record=1
while eof(#1)=0
line input #1, r$
results(record,box)=val(word$(r$,1))
results(record,break)=val(word$(r$,2))
results(record,turn)=val(word$(r$,3))
results(record,strch)=val(word$(r$,4))
results(record,finish)=val(word$(r$,5))
results(record,lngs)=val(word$(r$,6))
results(record,art)=val(word$(r$,7))
results(record,grad)=val(word$(r$,8))
record=record+1
wend
close #1
'lets just check we got it
numrecords=record-1
for n= 1 to numrecords
print results(n,box),results(n,break),results(n,turn),results(n,strch),results(n,finish),results(n,lngs),results(n,art),results(n,grad)
next
'now put it into your format
box11=results(1,box)
box12=results(2,box)
box13=results(3,box)
box14=results(4,box)
box15=results(5,box)
box16=results(6,box)
bk11=results(1,break)
bk12=results(2,break)
bk13=results(3,break)
bk14=results(4,break)
bk15=results(5,break)
bk16=results(6,break)
trn11=results(1,turn)
trn12=results(2,turn)
trn13=results(3,turn)
trn14=results(4,turn)
trn15=results(5,turn)
trn16=results(6,turn)
strch11=results(1,strch)
strch12=results(2,strch)
strch13=results(3,strch)
strch14=results(4,strch)
strch15=results(5,strch)
strch16=results(6,strch)
finish11=results(1,finish)
finish12=results(2,finish)
finish13=results(3,finish)
finish14=results(4,finish)
finish15=results(5,finish)
finish16=results(6,finish)
lngs11=results(1,lngs)
lngs12=results(2,lngs)
lngs13=results(3,lngs)
lngs14=results(4,lngs)
lngs15=results(5,lngs)
lngs16=results(6,lngs)
art11=results(1,art)
art12=results(2,art)
art13=results(3,art)
art14=results(4,art)
art15=results(5,art)
art16=results(6,art)
grad11=results(1,grad)
grad12=results(2,grad)
grad13=results(3,grad)
grad14=results(4,grad)
grad15=results(5,grad)
grad16=results(6,grad)
(this is what it produces) very not correct
1 0 3 7 7 7 6 38.82
1 0 2 6 4 4 4 38.86
1 0 5 6 8 7 6 38.9
1 0 1 6 6 3 3 32.13
1 0 8 6 5 5 5 32
1 0 6 7 8 5 5 31.84
2 0 0 0 1 7 7 5
2 0 0 0 6 7 6 4
2 0 0 0 1 6 8 7
2 0 0 0 3 7 5 5
2 0 0 0 8 8 6 6
2 0 0 0 4 5 6 3
(i was getting this but wanted to change need to add fields )
1 xxxxxx 3 7 7 7 6 38.82 4
1 xxxxxx 2 6 4 4 4 38.86 4
1 xxxxxx 5 6 8 7 6 38.90 4
1 xxxxxx 1 6 6 3 3 32.13 4
1 xxxxxx 8 6 5 5 5 32.00 4
1 xxxxxx 6 7 8 5 5 31.84 6
2zzzzzz 1 7 7 5 3 31.93 6
2zzzzzz 6 7 6 4 4 31.42 6
2zzzzzz 1 6 8 7 7 32.48 6
2 zzzzzz 3 7 5 5 4 31.72 6
2 zzzzzz 8 8 6 6 5 32.25 6
2 zzzzzz 4 5 6 3 2 31.36 6
(should be like this)
fields and field size
name(22)bx(1)bk(1)trn(1)ins1(4) str(1)(ins2(4) fin(1) lngs(4) time(5) grd(3).....
there is a in-field money , i think it's between time and grd or lngs and time.
let me know what I need to do , I got it really screwed up