formfeed problem

Thread Tools Search this Thread
Operating Systems Solaris formfeed problem
# 1  
Old 02-03-2005
Question formfeed problem

i am running an .sql script in sqlplus which is spooling in a file. but when i am opening the file using vi editor it is showing ^L in front of 1st,2nd and last line.
when i am opening the file with cat this problem is not there.
how to solve this problem?
this above mentioned file is the input to another programe so the ^L is absolutely not desirable.
please try to give a solution!
# 2  
Old 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


The output on the screen should look like this:


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.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

sed or awk: delete n lines following a formfeed

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

2. UNIX for Dummies Questions & Answers

sed Or Grep Problem OR Terminal Problem?

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

3. IP Networking

Problem with forwarding emails (SPF problem)

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

4. UNIX for Dummies Questions & Answers

DHCP problem and eth1 problem

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

5. Red Hat

Mail Problem. Maybe, it is a DNS Problem!

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

6. AIX

user login problem & Files listing problem.

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

7. Shell Programming and Scripting

ssh script problem problem

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

8. UNIX for Advanced & Expert Users

Formfeed after each file

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

9. UNIX for Advanced & Expert Users

lp FormFeed Escape characters

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

10. UNIX for Dummies Questions & Answers

FormFeed BEFORE printing a job

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
Login or Register to Ask a Question

Featured Tech Videos