Re: load data with embeded New Line character

Thanks Ian. 

That should fix the issue.

Prince.

Ian <[EMAIL PROTECTED]> wrote in message news:<[EMAIL PROTECTED]>...
> Prince Kumar wrote:
> 
> > What is the best way of loading data which has ENTER/new line (ie, ^M)
> > character as the part of the data?
> > 
> > say I have data as follows for table TAB1 (cust#, datetime, memo,
> > child)
> > 
> > 7579, "2001-09-14 15:06:26", "sample memo with ^M
> > New Line^M
> > ",1234
> > 
> 
> Use the load option MODIFIED BY DELPRIORITYCHAR
> 
> 
> 
> 
> -----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
> http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
> -----==  Over 100,000 Newsgroups - 19 Different Servers! =-----