Greetings,

I am working on a Perl script to read through an Oracle extract file containing two fields. The first is a table key field and the second is a 2000 max character varchar2 field containing notes. Some of those notes contain embedded new line characters. The script performs a replacement on a certain pattern (if present).

I read the file binary raw, unpack, search & replace on the pattern, chomp the field, prepare the field for updating (including eliminating field delimiter characters and prepping embedded apostrophes), format the update statement, and update.

I added in code to attempt to escape newlines (i.e. replace \n with \n) and I just gave pack a try to format the update statement (using both a & b to encode the update statement).

Is there a special character I can substitute new lines for? Is there a function to help out here?

BTW, I am accessing Oracle via Win32::ODBC

Thanks
Mark

Related Blogs

• Data Migration and Import: Using field delimiter characters in the …
• How to Drive Traffic to Your Web Site Using Free Ezine Advertising …
• Play As Chain Chomp in Super Mario 64 – Has Anyone Ever?
• Adobe InDesign CS4 Nested Styles And Nested Line Styles …
• Dr. Queks Perl Script Archives. – Bibliothèque Virtuelle

Bookmark It

Hide Sites