Re: SQL*LOADER: Skipping over fields in text file?

Roberto <rprendin_at_magi.com> wrote:

>-- 1 2 3
>-- 123456789012345678901234567890123456789012345678901234567890
>-- John Doe JUNK FIELD1 JUNK FIELD2 123 Halloween Drive
>-- Mary Smith MORE JUNK EVEN MORE 567 Street Road
>ABOVE IS COMMENTED OUT JUST FOR REFERENCE...
>
>Name position(001-012) char,
>Address position(039-050) char )
>
>Be VERY specific when defining the positions.This numbering system at
>the top can be extremely useful. Loader will only load what YOU tell
>it to and ignores everything else. Goodluck, Rob

   My example was somewhat oversimplied. Here's a closer picture of what the file could look like. Keep in mind, it's a variable-length record with the fields delimited by tabs:

John Doe	JunkField#1	MoreJunk	123 Main Street
Mrs. ReallyLongLastName		short	345 River Road

Note that the fields don't line up anymore. And one of the fields I want to skip is null (two tabs next to each other) in the second record.

Does this significantly complicate my situation?

Thanks for taking the time to respond. Any further assistance would be appreciated.

Jim. Received on Sat Nov 02 1996 - 00:00:00 CET