| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: need help with sql*loader problem
If you can actually see the carriage return character (^M), which is usual
in such cases, then you can substitute that character directly. To get that
character when typing, hit Control-V and then Control-M. Control-V makes the
next character to be typed appear as it is without performing a vi function
or something else.
Cheers,
Vasan.
-----Original Message-----
From: Mladen Gogala [mailto:gogala_at_sbcglobal.net]
Sent: 22 May 2004 03:07
To: oracle-l_at_freelists.org
Subject: Re: need help with sql*loader problem
And exactly how should two spaces between the slashes help with the carriage retunrns? If you said 1,$s/\n// or 1,$s/\r// I would have nodded my head in agreement, but two slashes??? Why not two slashdots?
On 05/21/2004 08:38:00 PM, Ryan wrote:
> yeah or opening it in vi and doing the following:
>
> 'escape' (takes cursor to the bottom of the screen)
>
> 1,s/ //g
>
> That is two spaces between the the slashes. That should get rid of your
> carriage returns.--
Mladen Gogala
Oracle DBA
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ___________________________________________________________________________ This email and any attached to it are confidential and intended only for the individual or entity to which it is addressed. If you are not the intended recipient, please let us know by telephoning or emailing the sender. You should also delete the email and any attachment from your systems and should not copy the email or any attachment or disclose their content to any other person or entity. The views expressed here are not necessarily those of Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you. Churchill Insurance Group plc. Company Registration Number - 2280426. England. Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1 1DP. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Mon May 24 2004 - 04:29:33 CDT
 |
 |