Concatenating lines and formatting.

Tonka52 · #1 (**permalink**) 11-30-2004

Hi,

I have a html file which is unformatted and need to concatenate the lines between each "table" statement in order to run an awk statement on it. Here is the example of the raw file:

<table border="0" cellspacing="0" cellpadding="0" class="playerDetails">
def
<tr>
<th colspan="3">
Michael Anthony

</th>
</tr>
<tr>
<td>
<ul>

<li><a href="test.txt">Email</a></li>

<li><a href="test2.htm=">See details</a></li>

</td>
<td>
Darren Brown<br />

077087313<br />

Yes<br />

</td>
</tr>
</table>

I need it to end up like:

<table> .....[all other info].....</table>
<table>...[next load of info]......</table>

and so on.....

zazzybob · #2 (**permalink**) 11-30-2004

A job for perl, IMHO....

Code:

#!/usr/bin/perl

open( HANDLE, "< ./somefile" );
@file=<HANDLE>;
close(HANDLE);

$flag=0;

foreach (@file)
{
  if ( $_ =~ "<table" ) {
     $flag=1;
  }
  elsif ( $_ =~ "</table>" ) {
     print( "$_" );
     $flag=0;
  }
  if ( $flag == 1 ) {
     $_ =~ s/\n//g;
     print( "$_" );
  }
}

Cheers
ZB

Ygor · #3 (**permalink**) 11-30-2004

Awk one liner...

awk '/<table/,/<\/table/{printf $0 ($0~"</table"?"\n":"");next}{print}' file1 > file2

Tonka52 · #4 (**permalink**) 12-01-2004

Thanks guys! Worked a charm.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Concatenating the two lines in a file	srivsn	Shell Programming and Scripting	6	07-17-2008 10:03 PM
Concatenating multiple lines to one line if match pattern	phixsius	Shell Programming and Scripting	13	01-24-2008 11:02 PM
concatenating strings..	jt_csv	Shell Programming and Scripting	2	02-07-2007 10:09 PM
Formatting lines in shell script	dreams5617	Shell Programming and Scripting	8	01-30-2007 01:24 AM
Formatting the lines	dreams5617	UNIX for Dummies Questions & Answers	2	01-29-2007 06:46 PM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by