Re: convert newlines UNIX - DOS / DOS to UNIX

From: Mladen Gogala <>
Date: Sat, 15 Jan 2011 18:51:42 +0000 (UTC)
Message-ID: <>

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.

Received on Sat Jan 15 2011 - 12:51:42 CST

Original text of this message