Visit Our UNIX and Linux User Community


Request for advise on how to remove control characters in a UNIX file extracted from top command


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Request for advise on how to remove control characters in a UNIX file extracted from top command
# 8  
Old 09-05-2013
Try
Code:
awk '. . . ; {for (i=12; i<=NF; i++) printf "%s ", $i; printf "\n"}

This User Gave Thanks to RudiC For This Post:
# 9  
Old 09-06-2013
Hi,

Thanks , command worked as expected. But in output i am getting more than 12th column i tried to merge using colspan of html
but still i am able to see more than 12 fields in html.

Code:
rm -f  output_2.html
echo -e "<html><head>" >> output_2.html
echo -e "<meta http-equiv="content-type" content="text/html\; charset=Cp1252">" >> output_2.html
echo -e "<!-- base href="http://apexdev.us.oracle.com:7778/pls/apx11w/" -->" >> output_2.html
echo -e "<style type="text/css">" >> output_2.html
echo -e "table {" >> output_2.html
echo -e "border-width:0px 0px 0px 0px;" >> output_2.html
echo -e "}" >> output_2.html
echo -e "td {" >> output_2.html
echo -e "font-family:Calibri;" >> output_2.html
echo -e "font-size:12pt;" >> output_2.html
echo -e "}" >> output_2.html
echo -e "p {" >> output_2.html
echo -e "font-family:Calibri;" >> output_2.html
echo -e "font-size:12pt;" >> output_2.html
echo -e "}" >> output_2.html
echo -e "</style>" >> output_2.html
echo -e "</head>" >> output_2.html
echo -e "<body>" >> output_2.html
echo -e "<br>" >> output_2.html
echo -e "<table border="0" cellpadding="0" cellspacing="0">" >> output_2.html
echo -e "<tbody id="data">" >> output_2.html
sed -r -i 's/\s+/ /g' top_list.txt
awk 'BEGIN{RS="\n";}
{
print "<TR>";
for (i=1; i<=11; i++)
{
printf ( "<TD>" );
printf "&nbsp;";
printf ( $i );
printf "&nbsp;";
printf ( "</TD>" );
}
for (j=12; j<=NF; j++)
{
printf ( "<TD colspan="10">" );
printf ( $j,"%s ");
printf ( "</TD>" );
}
printf "\n";
print "</TR>";
print "\n";
}' top_list.txt >> output_2.html
echo -e "</tbody></table>" >> output_2.html
echo -e "<br>" >> output_2.html
echo -e "</body></html>" >> output_2.html


Is there anyother way to get.

Please advise.

Thanks,
Regards,
karthikram

Previous Thread | Next Thread
Test Your Knowledge in Computers #380
Difficulty: Medium
Apple's macOS (previously known as Mac OS X or OS X) is a UNIX 03 registered product.
True or False?

10 More Discussions You Might Find Interesting

1. Red Hat

Special control characters in file

Hi Guys, We receive some huge files on to Linux server. Source system use FTP mechanism to transfer these files on our server. Occasionally one record is getting corrupted while transfer, some control characters are injecting into the file. How to fix this issue ? please advice ? Sample... (2 Replies)
Discussion started by: srikanth38
2 Replies

2. Shell Programming and Scripting

How to view the control characters in a file?

Hello, How can I view control and special characters of a text file?. For example, space, tabs, new line chars etc. Can I use hexdump for it? Thanks (3 Replies)
Discussion started by: reddyr
3 Replies

3. UNIX for Dummies Questions & Answers

Control characters in UNIX

Hi, My files are showing some control characters in vi editor ^M ^@ and somtimes ^H I removed ^M with %s/^M//g command but how to represent ^@ and ^H e.g. for ^M it is hold ctrl then v and m.. Please help.. I am very new to unix.. (7 Replies)
Discussion started by: prabhat.diwaker
7 Replies

4. Shell Programming and Scripting

Extra control characters being added when I create a file using cat command

Hi, I am using Cygwin.I created a new file and type into it using cat > newfile. When I open this using vi editor, it contains loads of extra control characters. Whats happening? (1 Reply)
Discussion started by: erora
1 Replies

5. Shell Programming and Scripting

How to remove Ctlr-M characters from file from a unix script

There are 10 files present which have Ctlr-M characters appended to each line of all files. I have a unix script which processes the files in a loop. And there is an inner loop which processes each line in the file concerned. #inputFile is a variable which has the file name of the input... (2 Replies)
Discussion started by: akashtcs
2 Replies

6. Shell Programming and Scripting

display all possible control characters from .xml file in unix

Hi, I have a .xml file in unix. We are passing this file through a xml parser. But we are getting some control characters from input file and XML parser is failing for the control character in file.Now I am getting following error, Error at byte 243206625 of file filename_$.xml: Error... (1 Reply)
Discussion started by: fantushmayu
1 Replies

7. Shell Programming and Scripting

Hidden control characters in a Unix Text File!

Can anyone seem to know how to find out whether a UNIX text file has 'hidden' control characters? Can I view them using 'vi' by some command line options? If there are control characters in a text file which are invisible/hidden.. then how do I get rid of them? Your intelletual answers are... (6 Replies)
Discussion started by: kewl_guy
6 Replies

8. Shell Programming and Scripting

Which one is faster to remove control m characters?

I have a file with millions of records...Before I experiment, I would like to know which one is faster. Both the commands work absolutely fine on a smaller set of records. Please advice. sed 's/^M//g' ${INPUT_FILE} > tmp.txt mv tmp.txt ${INPUT_FILE} tr -d "\15" < ${INPUT_FILE} > ... (11 Replies)
Discussion started by: madhunk
11 Replies

9. Programming

Identifying and removing control characters in a file.

What is the best method to identify an remove control characters in a file. Would it be easier to do this in Unix or in C. (0 Replies)
Discussion started by: oracle8
0 Replies

10. UNIX for Dummies Questions & Answers

Remove control characters

Hi, When I do a man and save it into a file, I end up getting a lot of control characters. How can I remove them?? I tried this: /1,$ s/^H//g But I get an error saying "no previous regular expression". Can someone help me with this. Thanks, Aravind (5 Replies)
Discussion started by: aravind_mg
5 Replies

Featured Tech Videos