Re: Is this possible ??

[Evan Harris <auctionitis@xxxxxxxxx>]

Hi Don

seems like it would be easier to leave the IBM i out of it in this case.
You have a PC file and a spreadsheet, and you are dealing with text files
so perl, Python, Java, or any language you can run on the PC would probably
be a lot easier.

Export the spreadsheet to a CSV and you can probably read and write the
files directly on the PC without worrying about CCSID, transferring to/from
the i, messing with the IFS and DB conversion etc.

Or just use an editor as suggested by Buck.


On Tue, Feb 11, 2014 at 3:27 AM, Don Cavaiani <dcavaiani@xxxxxxxxxxxxx>wrote:

> Strange question here.  I have a older DOS PC football game with a 'stats'
> file with an .lgs extension.  This file has each teams several offensive
> and defensive 'ratings' in a 1 to 9 format.  I have created a spreadsheet
> which I can get up to the IBM i.  The sheet has each team's various
> 'UPDATED' stats in columns across the team row.  I want to get the PC file
> to the IBMi in an understandable format, then write an RPG program to
> access it and change each of those stats according to the excel uploaded
> file, and then RETURN the file to the PC so the game may be played again.
>  I know finding the PC file record length is an issue, and understanding
> the PC file layout is confusing at best, not to mention how it 'converts'
> when uploaded to the IBMi.
>
>
>
> Don Cavaiani
> --
> ... And FORGIVE US our trespasses As WE FORGIVE those who trespass against
> us ...
> Author:  Jesus - circa 2,000 years ago
>
> All your ways may be straight in your own eyes,
> but it is the LORD who weighs hearts.    Proverbs 21:2
> --
> This is the PC Technical Discussion for IBM i (AS/400 and iSeries) Users
> (PcTech) mailing list
> To post a message email: PcTech@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/pctech
> or email: PcTech-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/pctech.