Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Using SQL*Plus for loading file containg CR/LF as value of column - use sed/awk

Re: Using SQL*Plus for loading file containg CR/LF as value of column - use sed/awk

From: eye <anonymouz_at_xs4all.nl>
Date: Thu, 30 Jan 2003 21:18:58 +0100
Message-ID: <3e3988b6$0$49103$e4fe514c@news.xs4all.nl>


I would:
use SED and/or AWK to convert all CR/LFs in between the beginning of the line and the ';' making use of so called regular expressions. SED (and AWK) is standard available on (any) unix platform (man sed, man awk) and for Win32/DOS some ports can be found, e.g. www.gnu.org. Anyhow the acquaintance with regular expressions is a valuable treasure in your personal toolkit. Usually in one or a few lines of regex code you can achieve amazing things. Sorry for not having worked out the code for your problem, lack of time forbids.
Erik Ykema Received on Thu Jan 30 2003 - 14:18:58 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US