Re: convert newlines UNIX - DOS / DOS to UNIX

From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Sat, 15 Jan 2011 18:51:42 +0000 (UTC)
Message-ID: <pan.2011.01.15.18.51.42_at_gmail.com>



On Thu, 13 Jan 2011 12:52:30 -0800, oldyork90 wrote:

> I want to build an oracle function, in a 10g Unicode database, that
> accepts a varchar, of any length, and returns a translation. It will
> translate all found DOS NL to UNIX NL, or UNIX NL to DOS NL. It has to
> be bullet proof. I'm off to give this a try with the regular express
> package, but I'd like to get any input from the Oracle Jones. Thank you.

Let me try and take a shot: you would need to replace \n\r (DOS standard) with \n (Unix standard). You mentioned Oracle 10g, which supports regular expressions. That shouldn't be very hard to do.

-- 
http://mgogala.byethost5.com
Received on Sat Jan 15 2011 - 12:51:42 CST

Original text of this message