From dwagoner@arsenaldigital.com Mon, 30 Jul 2001 11:37:51 -0700 From: David Wagoner Date: Mon, 30 Jul 2001 11:37:51 -0700 Subject: SQL*Loader question- Transforming Data Message-ID: MIME-Version: 1.0 Content-Type: text/plain I’m using SQL*Loader to populate a database table with transaction records.  The data file contains some transactions that I want to exclude from the load and they all contain the same text string, something like “xxx,yyy,FLAG_TEXT,xxx,yyy”.  Can I use a SQL statement in the SQL*Loader control file to filter out those transactions?  Something that functions like this pseudocode:   if field like ‘%FLAG_TEXT%’ then null; else load;     I’ve been reading the new Oracle SQL*Loader book by Gennick and Mishra which is a good book, but I’m still uncertain about this.     Thanks,    AUTOTEXTLIST \s "E-mail Signature" David B. Wagoner Database Administrator Arsenal Digital Solutions Worldwide Inc. 4815 Emperor Blvd., Suite 110 Durham, NC 27703 Tel. (919) 941-4645 Fax (919) 474-0695 Email mailto:dwagoner@arsenaldigital.com Web http://www.arsenaldigital.com/                                                                                                             ***  NOTICE  *** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, work product or exempt from disclosure under applicable law.  If you have received this message in error, or are not the named recipient(s), please immediately notify the sender at (919) 941-4645 and delete this e-mail message from your computer.  Thank you.