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

Sponsored Content

Top Forums Shell Programming and Scripting Request for advise on how to remove control characters in a UNIX file extracted from top command Post 302850895 by karthikram on Friday 6th of September 2013 01:32:22 AM

09-06-2013

Registered User

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

karthikram

View Public Profile for karthikram

Find all posts by karthikram

10 More Discussions You Might Find Interesting

1. 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

2. 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.

3. 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} > ...

4. 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...

5. 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...

6. 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...

7. 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?

8. 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..

9. 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

10. 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...

LEARN ABOUT PHP

tidy.html

TIDY.HTML(3)								 1							      TIDY.HTML(3)

tidy::html - Returns atidyNodeobject starting from the <html> tag of the tidy parse tree

       Object oriented style

SYNOPSIS

       tidyNode tidy::html (void  )

DESCRIPTION

       Procedural style
       tidyNode tidy_get_html (tidy  $object)

	Returns a tidyNode object starting from the <html> tag of the tidy parse tree.

PARAMETERS

	      o $object
		- The Tidy object.

RETURN VALUES

	Returns the tidyNode object.

EXAMPLES

       Example #1

	      tidy.html(3) example

	      <?php
	      $html = '
	      <html>
		<head>
		  <title>test</title>
		</head>
		<body>
		  <p>paragraph</p>
		</body>
	      </html>';

	      $tidy = tidy_parse_string($html);

	      $html = $tidy->html();
	      echo $html->value;
	      ?>

	      The above example will output:

	      <html>
	      <head>
	      <title>test</title>
	      </head>
	      <body>
	      <p>paragraph</p>
	      </body>
	      </html>

NOTES

       Note

	       This function is only available with Zend Engine 2 (PHP >= 5.0.0).

SEE ALSO 
tidy.body(3), tidy.head(3).
PHP Documentation Group 													      TIDY.HTML(3)

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Remove control characters

Discussion started by: aravind_mg

2. Programming

Identifying and removing control characters in a file.

Discussion started by: oracle8

3. Shell Programming and Scripting

Which one is faster to remove control m characters?

Discussion started by: madhunk

4. Shell Programming and Scripting

Hidden control characters in a Unix Text File!

Discussion started by: kewl_guy