I need to dump the output of an Oracle SQl query to a file, but unfortunately it replaces all NULL field with a carrage return. Correct carrage returns can be determined by the fact the have 200 spaces in front of them due to line padding. To fix the problem and geteverything back into correct allignment, I need to replace all improper carrage returns with a single space. I guess the algorithm would be something like Find all correct carrage returns, replace with a placeholder. Replace all carrage returns with a single space Replace placeholders with carrage returns But I don't know how to implement this. Can it be done with a sed script or 3, or will it require something more complicated? - doug -- _____________________________________________________________ Network Operations Engineer - Big Pond Advance Satellite Ericsson Australia - Level 5, 184 The Broadway, Sydney 2000 Ph: +61-416-085-390 Email: [EMAIL PROTECTED] -- SLUG - Sydney Linux User Group Mailing List - http://slug.org.au/ More Info: http://slug.org.au/lists/listinfo/slug
