HP3000-L Archives

October 1996, Week 5

HP3000-L@RAVEN.UTC.EDU

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
Greg Chaplin <[log in to unmask]>
Reply To:
Greg Chaplin <[log in to unmask]>
Date:
Thu, 31 Oct 1996 08:40:35 +1000
Content-Type:
text/plain
Parts/Attachments:
text/plain (30 lines)
As far as I know, records in PC files are delimited by a carriage
return / linefeed combination.  Some non-standard PC applications
recognise only the CR as the end-of-record marker, but Excel, Access,
etc, recognise the CR/LF as the end-of-record.

Reflection file transfers allow the end-of-record marker to be set as
either CR/LF (default) or just CR - this can be changed in the file
transfer setup or via Reflection scripts/commands.  Also, the
end-of-file marker can be set as Control-Z in the same way.  I don't
know what the standard end-of-file marker is for PC files, but when I
download a CSV (comma or tab separated file) from the HP3000 to my PC
with the Ctrl-Z eof, Excel picks it up as a separate record.

The other thing to think about with file sizes is that the default
for PC files is to have variable length records - ie. trailing blanks
removed.  This is again configurable for Reflection file transfers
from the HP.  When calculating file sizes on the HP, I use:
    filesize (bytes) = ( (record_length + 2) * eof) + 1
2 bytes per record is added for the CR/LF.  I have found this to be
accurate when keeping the file format - ie. fixed-length records on
the HP & PC, or variable-length on both.  Some of my files have to
chopped up into 1.44mb diskette sized chunks when they are being
created on the HP, & using this formula has worked so far.

Greg Chaplin
UniSuper
Level 28, 367 Collins St,      Email: [log in to unmask]
Melbourne 3000,                 Phone: +61 3 9648 4145
Australia.                             Fax: +61 3 9648 4141

ATOM RSS1 RSS2