RE: Output from PF to Excel XLS file in IFS

[meovino@xxxxxxxxxxxxxxxxx]

Reeve,

Yes, it's a long B/L number, all numeric digits.  It's nothing wrong with
LTL/38, it's two "features" of Excel working in tandem:

1.  Text qualifiers in a CSV file are ignored if every character in the
field is numeric or blank.
2.  Excel displays long (> 12 digit) numbers as scientific notation, no
matter how wide you make the column.

The suggestion of the products from Kemetech look like they'll fit our
needs quite nicely.

Thanks!
Mike E.




                                                                                
                                          
                    "Reeve Fritchman"                                           
                                          
                    <reeve@ltl400.com>          To:     "'Midrange Systems 
Technical Discussion'"                         
                    Sent by:                     <midrange-l@midrange.com>      
                                          
                    midrange-l-bounces@mi       cc:                             
                                          
                    drange.com                  Subject:     RE: Output from PF 
to Excel XLS file in IFS                  
                                                                                
                                          
                                                                                
                                          
                    02/07/03 02:01 PM                                           
                                          
                    Please respond to                                           
                                          
                    Midrange Systems                                            
                                          
                    Technical Discussion                                        
                                          
                                                                                
                                          
                                                                                
                                          




Hmmm...this would have to be something like a long B/L number (an alpha
field) or a shipment number (FHSN?).  Let me check with one of my guys; I'm
sure we figured out a way to do this (but I might be wrong).

Say hello to HBC III and RWE JR. for me...

-reeve

> -----Original Message-----
> From: midrange-l-bounces@midrange.com
[mailto:midrange-l-bounces@midrange.com] On Behalf Of
> meovino@estes-express.com
> Sent: Friday, February 07, 2003 1:24 PM
> To: Midrange Systems Technical Discussion
> Subject: Re: Output from PF to Excel XLS file in IFS
>
>
> > forgive me for being flippant, but if the user 'absolutely, positively,
> > will not accept anyting but an honest-to-god XLS file', and he/she
> actually
> > has the pull to make such an unreasonable mandate, tell him/her that
the
> > cost of purchasing SEQUEL will come out of her/his budget!  ;)
>
> Unfortunately, not an option ;-)  I'm trying to get them to do the math
to
> justify the cost based on timesavings.  It will work out, but I'm not
going
> to do it for them.
>
> > as far as other options - I've never done this, but can't you (at least
> > 'semi') automate the process of importing external data (in this case,
a
> > .csv) into an excel template file, creating a new excel spreadsheet?
> Maybe
> > a VB macro, or some such.
>
> CSV won't cut it; we're doing that right now.  Excel displays numbers
with
> more than 12 (?) digits in scientific notation, no matter how wide you
make
> the column.  It's a "feature."  I need to be able to format that column
as
> text.  If we wrap the value in double quotes with the CPYTOIMPF command,
> Excel still treats the field as a number if there's no text in the field
> (even blank spaces won't help).
>
> VB macros are not an option.  We want to mail this out to customers, from
a
> program that runs on schedule in batch, with no human intervention.
>
> Mike E.
>
>
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
> To post a message email: MIDRANGE-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.



_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.