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!

Need help filtering non printable characters

andy_schnelleJun 4 2012 — edited Jun 4 2012

Hi all,

I work at a data warehouse and one of our clients has requested we eliminate two non-printable character which are appearing in a field. We have decided to filter it out during the ETL process when loading the data into our database. I'm not sure how to do this and I have come to the community here for help. Does anyone have any ideas what the syntax would look like?

Here is an example similar to mine (fixed text file):

............
SAMPLE_PRODUCT_CODE POSITION(440:444) CHAR,
SAMPLE_PRODUCT_CODE2 POSITION(445:449) CHAR,
ANOTHER_FIELD POSITION(485:485) CHAR,
..............

In my case I have one field (SAMPLE_PRODUCT_CODE2) which periodically has two non printable characters (0x0C which is a “form feed” in both EBCDIC and ASCII) separated by several blank characters. I was wondering if it will be possible to handle this in our data load and enter a NULL value through the NULLIF function for these records. Thanks in advance for any help.