HP3000-L Archives

November 2004, Week 4

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:
Richard Barker <[log in to unmask]>
Reply To:
Richard Barker <[log in to unmask]>
Date:
Wed, 24 Nov 2004 10:10:00 +0100
Content-Type:
text/plain
Parts/Attachments:
text/plain (39 lines)
Hi

I suspect this may have come up on the list before, but I will ask anyway.

I am FTP'ing some fixed length ascii text files from an HP3000 to my windows
box and importing them into an SQL data warehouse.  The problem I have is,
if I use ascii as a transfer option, some of the European characters
disappear from the text.  If I use the binary option, they appear correctly,
but the carriage returns and line feeds are, effectively, missing
(technically they are still there of course).

Now I using C#.NET to do this, so I could write a program to re-add the CR
at the correct record position, but I wonder if anyone else had come up with
a better solution to this issue.

BTW- I have no control at the HP3000 end.



==================================
This message contains confidential information and is intended solely for
the use of the individual or entity to whom it is addressed. If you are not
the named addressee you should not disseminate, distribute or copy this
email. Please inform the sender immediately if you have received this e-mail
by mistake and delete this email from your system. Email transmission cannot
be guaranteed to be secure or error-free as information could be
intercepted, corrupted, lost, destroyed, arrive late or be incomplete. The
sender therefore does not accept liability for any errors or omissions in
the contents of this message, which arise as a result of email transmission.
If verification is required please request a hard copy version. No contracts
may be concluded on behalf of Virgin Express SA/NV by means of email
communication. Finally, the recipient should check this e-mail and any
attachments for the presence of viruses. The company accepts no liability
for any damage caused by any virus transmitted by this email.
==================================

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

ATOM RSS1 RSS2