SqlLdr and multiline records

From: Scott Vickery <syv_at_mindspring.com>
Date: 1998/03/06
Message-ID: <35004df5.23240922_at_dggis.rtpnc.epa.gov>#1/1


[Quoted] I need to use SqlLdr to load fields into a table where the fields are not arranged in columnar format. That is Field 1 will be in the ASCII file with several lines of text. Field 2 will be seperated by Field 1 by one blank line, Field 3 willl be seperated from Field 2 by one blank line, and so on. Basically, like this:

  Field 1: A lot of text goes here that can wrap to multiple lines (like this .....)

  Field 2: Same as field 1 above

  Field n:

Is there a way to do this with SqlLdr?

Scott Vickery Received on Fri Mar 06 1998 - 00:00:00 CET

Original text of this message