There are two types of FTP, BINARY or ASCII. Default is BINARY.
Try entering "ASC" before you run the put command. "BIN" will ensure a
BINARY copy. Normally use ASC for text files, BIN for other files (i.e. zip,
tar, exes, etc).
John.
-----Original Message-----
From: Steven
[mailto:oracledba-ezmlmshield-x34074837.[Email address protected]
Sent: 28 July 2006 12:16
To: LazyDBA Discussion
Subject: unwanted Carriage Returns in file
Hi;
I am on a PC running windows 2000 Professional.
I am transferring a notepad, "blah_blah_blah.txt", file to a production
server using "psftp".
The command(s) I use is/are :
On the PC : Start Run cmd
At the DOS prompt : psftp -l gbank blahukblahe108 -P 16
Prompt for "password :" , and then respond "*********"
At the "psftp" prompt :
put c:\Map_Load\blah_blah_blah.txt
/u01/staff/gbank/Lower_Directory/blah_blah_blah.txt
All this looks to work OK; *BUT* ...........
When we load the data, in the file, into the database, and then try to
use it, we get issues.
The issues being that the "psftp" transfer put carriage returns at the
end of every line!
Early reading on "psftp", one of the only 2 authorized tools for
accessing the live server,
suggests that it can only transfer files in binary, so we would not
expect carriage returns
to be inserted.
Has anyone any ideas on what is happenning, or what I am doing wrong?
Note: I am not alllowed "telnet" access to the server, so I cannot "vi"
the file to strip out
the carriage returns.
Thanks, in advance
Steve
This email and any files attached are intended for the addressee and may
contain information of a confidential nature. If you are not the intended
recipient, be aware that this email was sent to you in error and you should
not disclose, distribute, print, copy or make other use of this email or its
attachments. Such actions, in fact, may be unlawful. In compliance with the
various Regulations and Acts, General Dynamics UK Limited reserves the right
to monitor (and examine for viruses) all emails and email attachments, both
inbound and outbound. Email communications and their attachments may not be
secure or error- or virus-free and the company does not accept liability or
responsibility for such matters or the consequences thereof. Registered
Office: 100 New Bridge Street, London EC4V 6JA. Registered in England and
Wales No: 1911653.
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
-----------------------------------------
Information in this email including any attachments may be
privileged, confidential and is intended exclusively for the
addressee. The views expressed may not be official policy, but the
personal views of the originator. If you have received it in error,
please notify the sender by return e-mail and delete it from your
system. You should not reproduce, distribute, store, retransmit,
use or disclose its contents to anyone.
Please note we reserve the right to monitor all e-mail
communication through our internal and external networks.
SKY and the SKY marks are trade marks of British Sky Broadcasting
Group plc and are used under licence. British Sky Broadcasting
Limited (Registration No. 2906991), Sky Interactive Limited
(Registration No. 3554332), Sky-In-Home Service Limited
(Registration No. 2067075) and Sky Subscribers Services Limited
(Registration No. 2340150) are direct or indirect subsidiaries of
British Sky Broadcasting Group plc (Registration No. 2247735). All
of the companies mentioned in this paragraph are incorporated in
England and Wales and share the same registered office at Grant
Way, Isleworth, Middlesex TW7 5QD.
Oracle LazyDBA home page