02-03-2005
It's been a while since I have worked with SQL. I can tell your there is a solution to this problem in SQL and Unix. You may want to post on an Oracle forum. The SQL solution I remember is to basically set the page length longer then the output (like 100000). Unfortunately I cannot remember how to do that.
The Unix solution can be done several ways with a global replace. With vi just type this sequence
:%s/ctrl+v+L//g
The output on the screen should look like this:
:%s/^L//g
The ctrl+v+L may take a few tries to get it right, it's all about timing.
This will replace the ^L with nothing. This may offset your format so you may have to do this instead:
:%s/^L/ /g
The other easy option is with sed:
sed 's/^L//g' inputfile.txt > outputfile.txt
The ctrl+v+L is needed again to create the ^L. The output file will not contain the ^L.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
I have a problem where my printer formfeeds a blank page prior to printing a job. Anyone know where I can turn this off?
AIX O/S - RS-6000 (2 Replies)
Discussion started by: Docboyeee
2 Replies
2. UNIX for Advanced & Expert Users
I'm trying to modify the /usr/lib/lp/model/netstandard file to generate a header for all the print jobs that are sent, but there is no formfeed defined so the the job prints right after the header with no page break. What is the sequence I need in order to generate a formfeed? Or, do you have... (4 Replies)
Discussion started by: jgordon
4 Replies
3. UNIX for Advanced & Expert Users
Have a line printer that uses the script /etc/lp/interfaces/citoh script when processing print jobs. I've developed the header so that it will print a page break before the start of each page. When you print single files, this works fine. But, if you print multiple files (e.g. lp -d citoh... (8 Replies)
Discussion started by: jgordon
8 Replies
4. Shell Programming and Scripting
Hi
Please help me with the following problem with my script.
The following block of code is not repeating in the while loop and exiting after searching for first message.
input_file
==========
host001-01
host001-02
2008-07-23 13:02:04,651 ConnectionFactory - Setting session state... (2 Replies)
Discussion started by: pcjandyala
2 Replies
5. AIX
1) when user login to the server the session got colosed. How will resolve?
2) While firing the command ls -l we are not able to see the any files in the director. but over all view the file system using the command df -g it is showing 91% used. what will be the problem?
Thanks in advance. (1 Reply)
Discussion started by: pernasivam
1 Replies
6. Red Hat
Hi,
i've a redhat linux 9 upadated by redhat from 7 version to 9 version. A couple of days ago i was a problem with my mail, in other words i'm not able to get any email nor to send any email. I've a proxy configuration and i tried to set iptables in order to verify the port. The 110,255 and 995... (1 Reply)
Discussion started by: pintalgi
1 Replies
7. UNIX for Dummies Questions & Answers
At work I am trying to get this one Linux machine (let's call it ctesgm07) to behave like another Linux machine that we have (let's call it test007).
test007 returns the following version info:
cat /etc/debian_version: lenny/sid
uname -a: Linux test007 2.6.27-7-generic #1 SMP Tue Nov 4... (0 Replies)
Discussion started by: sllinux
0 Replies
8. IP Networking
Hi,
This is rather a question from a "user" than from a sys admin, but I think this forum is apropriate for the question.
I have an adress with automatic email forwarding and for some senders (two hietherto), emails are bouncing. This has really created a lot of problems those two time so I... (0 Replies)
Discussion started by: carwe
0 Replies
9. UNIX for Dummies Questions & Answers
I don't know if you guys get this problem sometimes at Terminal but I had been having this problem since yesterday :( Maybe I overdid the Terminal. Even the codes that used to work doesn't work anymore.
Here is what 's happening:
* I wanted to remove lines containing digits so I used this... (25 Replies)
Discussion started by: Nexeu
25 Replies
10. Shell Programming and Scripting
Hi Members,
This is my first post in this forum.
I want to do is match form feed lines one by one in a file and delete the next n lines (ex-3 lines) with the form feed character
Eg - Files looks like
Data 1
Data 2
Data 3
FF
Hdr1
Hdr2
Hdr3
Data4
Data5
FF
Hdr1
Hdr2
Hdr3 (9 Replies)
Discussion started by: yohan
9 Replies