you can try this: on jbase prompt 1) first prepare the screen ~--> TERM Y,X (Y are the columns, X are the rows)
2) next put the name of the file ~--> COMO ON filename 3) put your LIST command ~--> LIST FBNK.ACCOUNT CATEGORY (if you want only CATEGORY field) 4) the list scroll down in the screen (here is important the size of TERM, because if the rows are not enough, then you have to press some key of keyboard) 5) finally, lookup your file in the &COMO& directory ~/&COMO& --> 6) now you can edit the file to eliminate some wrogn characters and open in excel of something like that to exploit Regards On 28 dic, 14:18, Rick Weiser <[email protected]> wrote: > You want to use jBasic for this. > > OPEN 'FILE1' TO F.FILE1 ELSE STOP 201,'FILE1' > OPEN 'FILE2' TO F.FILE2 ELSE STOP 201,'FILE2' > > SELECT F.FILE1 > > DONE = 0 > LOOP > READNEXT ID ELSE DONE = 1 > UNTIL DONE DO > READ REC FROM F.FILE1,ID THEN > CUSTID = whatever > REC1 = '' > REC1<xx> = REC<accountbalance> > WRITE REC1 ON F.FILE2,CUSTID > END > REPEAT -- Please read the posting guidelines at: http://groups.google.com/group/jBASE/web/Posting%20Guidelines IMPORTANT: Type T24: at the start of the subject line for questions specific to Globus/T24 To post, send email to [email protected] To unsubscribe, send email to [email protected] For more options, visit this group at http://groups.google.com/group/jBASE?hl=en
