Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to ignore rows with a specific character

ziggy25Mar 10 2010 — edited Mar 12 2010

Hi guys,

If i have a CSV file that is in the following format

"fd!","sdf","dsfds","dsfd",
"fd!","asdf","dsfds","dsfd",
"fd","sdf","rdsfds","dsfd",
"fdd!","sdf","dsfds","fdsfd",
"fd!","sdf","dsfds","dsfd",
"fd","sdf","tdsfds","dsfd",
"fd!","sdf","dsfds","dsfd",

Is it possible to exclude any row where the first column has an exclamation mark at the end of the string.
i.e. it should only load the following rows

"fd","sdf","rdsfds","dsfd",
"fd","sdf","tdsfds","dsfd",

I am using Oracle 10.2

Thanks

Edited by: ziggy on Mar 10, 2010 5:37 PM

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 9 2010

Added on Mar 10 2010

#database-key-features, #export-import-sql-loader-external-tables

4 comments

2,019 views