RE: SQL*Loader question- Transforming Data

[Mercadante, Thomas F]

Dave,   How about   INTO TABLE PROJ FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY '"' WHEN FLAG_TXT != 'yourstringhere' (EMPNO, ENAME, FLAG_TXT)   Look at the sample ULCASE5.ctl that is in the ORACLE_HOME\RDBMS\DEMO directory.   Looks like it is something that would work for you. Tom Mercadante Oracle Certified Professional -----Original Message----- From: David Wagoner [mailto:[EMAIL PROTECTED]] Sent: Monday, July 30, 2001 2:56 PM To: Multiple recipients of list ORACLE-L Subject: SQL*Loader question- Transforming Data 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,   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:[EMAIL PROTECTED] 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.