| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.server -> Re: Using SQL*Plus for loading file containg CR/LF as value of column - use sed/awk
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
![]() |
![]() |