Re: Transferring a multiple record format logical from the AS/400 intoExcel

["Albert York" <albertyork@xxxxxxxxx>]

Yiou can slso create a Symbolic Link (SLK) file, which gives you control over how the spreadsheet looks.

Albert

> ----- Original Message -----
> From: rob@xxxxxxxxx
> To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
> Subject: Re: Transferring a multiple record format logical from	the	AS/400	intoExcel
> Date: Tue, 4 Nov 2008 15:49:22 -0500
>
>
> After doing further research on this I think you're better off either
> using
> http://www.scottklement.com/rpg/ifs.html
> to create a tab delimited file in the ifs by reading this MF lf in RPGLE,
> or,
> use his examples on writing directly to excel at
> http://faq.midrange.com/data/cache/533.html
>
> Because, what I am sure you are looking for is something like:
> A   B
> 001 CompanyA
> 001 Dallas
> 002 Fort Worth
> 002 CompanyB
> 001 Fort Wayne
> 003 CompanyC
> 001 Kendallville
> 002 Avilla
> where column A could be either company number or ship to number and column
> b could be company name or ship to name.
> Or some gyration of this.
>
> Avoid CSV or comma seperated variable, because of concerns about embedded
> commas in names like My Company, Inc.  There's workarounds but why take
> the hassle?
> Excel can easily read a tab delimited.  Try it.  I used Notepad and typed
> in the above columns and replaced the space with a tab.  Did a save as
> .txt.  Exited Notepad.  Then used Windows Explorer to find it.  And said
> Open With Excel and it did a fine job.  And, if one row has more or less
> columns, no problem.  Try that with notepad and then excel again.
>
>
>
> Rob Berendt
> --
> Group Dekko Services, LLC
> Dept 01.073
> Dock 108
> 6928N 400E
> Kendallville, IN 46755
> http://www.dekko.com
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.

>