Deleting table cells in a script Post: 302264897

Sponsored Content

Top Forums Shell Programming and Scripting Deleting table cells in a script Post 302264897 by phpfreak on Friday 5th of December 2008 05:34:34 AM

12-05-2008

Registered User

Ok I think I follow and I'm going to combine with my sed script to test. Please review it below as I've made some revisions. Remember, my goal is to remove everything between the table data tags and the content within will vary, it'll never be the same.

Code:

#!/bin/sh

#TD=0
CT=0
cat oldfile.html |while read LINE
do
    # Check to see if the LINE is non-empty, and has a <td> tag in it.
    if [ -n "$LINE" -a `echo $LINE |grep "<td>"` != "" ]
    then
        # Increase the TD counter by 1
        CT=`echo "$CT+1" |bc`
        
        # Check to see if the TD counter is at 6 (we are at 7th TD as the counter starts at 0 not 1)
        if [ "$CT" -eq 6 ]
        then
            # Use sed to remove this TD tag AND everything in between
            echo $LINE |sed -n '/<tr>/,/<\/tr> {
					    s/.*<tr>//
					    s/<\/tr>.*//
					    p
					    }' >> newfile.html
        else 
            echo $LINE >> newfile.html
        fi
    else
        echo $LINE >> newfile.html
    fi
    
    # If we are leaving a table row the we need to reset the TD counter!
    if [ -n "$LINE" -a `echo $LINE |grep "</tr>"` != "" ]
        CT=0
    fi
done

But I have two questions regarding your script. What is the var TD for? Notice I've commented it out for now. Lastly, since you set CT to 0, on the -very first count it will be 0 not 1 correct?

Last edited by phpfreak; 12-05-2008 at 06:45 AM..

phpfreak

View Public Profile for phpfreak

Find all posts by phpfreak

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

rm -i and deleting files from an index table

Hi, I am trying to make a command to delete my files out the trash can, but one at a time. I am currently using rm - i to do this, but the original file locations for restoring my files are heard on a .txt file which I am using as an index table. How would I manage to make it so that if I...

2. UNIX for Dummies Questions & Answers

Deleting cells that contain a specific number only from a space delimited text file

I have this space delimited large text file with more than 1,000,000+ columns and about 100 rows. I want to delete all the cells that consist of just 2 (leave 2's that are not by themselves intact): File before modification aa bb cc 2 NA100 dd aa b1 c2 2 NA102 de File after modification...

3. UNIX for Dummies Questions & Answers

Filling empty cells

How do you fill empty cells that do not have any data in them with "X" in a tab delimited text file? Thanks!

4. Shell Programming and Scripting

Moving new row and deleting old row to another table

Hi, I want to move a new row to another table if the field from new row doesn't have the first word that I categorized (like: IRC blablabla, PTM blablabla, ADM blablabla, BS blablabla). I already use this script but doesn't work as I expected. CHECK_KEYWORD="$( mysql -uroot -p123456 smsd -N...

5. Shell Programming and Scripting

In php, Moving a new row to another table and deleting old row

Hi, I already succeed moving a new row to another table if the field from new row doesn't have the first word that I categorized (like: IRC blablabla, PTM blablabla, ADM blablabla, BS blablabla). But it can't delete the old row. Please help me with the script. my php script: INSERT INTO...

6. UNIX for Dummies Questions & Answers

Deleting unwanted text from a table

Hi everyone, I have a microbial diversity table in the format ;k__kingdom; p__phylum, etc, somer rows have descriptions before the :k__ (like the af028349.1 below) is there a way I can get rid of this text (which is different every time) and keep all the other columns? Thanks a bunch! ;...

7. Programming

Perl script to merge cells in column1 which has same strings, for all sheets in a excel workbook

Perl script to merge cells ---------- Post updated at 12:59 AM ---------- Previous update was at 12:54 AM ---------- I am using below code to read files from a dir and print to excel. open(my $in, '<', $file) or die "Could not open file: $!"; my $rowCount = 0; my $colCount = 0;...

8. UNIX for Beginners Questions & Answers

BASH SCRIPT - Insert date into cells in cvs file

Hi, I'm looking to accomplish the following. Insert current date into three places/cells within a cvs, every time the bash script is executed. The cells are column A,B,C row 2. Row 1 is reserved for the headers. The file name is always orders.csv. These three cells we always have an old...

9. UNIX for Beginners Questions & Answers

Merge cells in all rows of a HTML table dynamically.

Hello All, I have visited many pages in Unix.com and could find out one solution for merging the HTML cells in the 1st row. (Unable to post the complete URL as I should not as per website rules). But, however I try, I couldn't achieve this merging to happen for all other rows of HTML...

10. UNIX for Beginners Questions & Answers

Remove duplicates in a dataframe (table) keeping all the different cells of just one of the columns

Hello all, I need to filter a dataframe composed of several columns of data to remove the duplicates according to one of the columns. I did it with pandas. In the main time, I need that the last column that contains all different data ( not redundant) is conserved in the output like this: A ...

LEARN ABOUT OPENSOLARIS

diffmk

diffmk(1)							   User Commands							 diffmk(1)

NAME

       diffmk - mark differences between versions of a troff input file

SYNOPSIS

       diffmk oldfile newfile markedfile

DESCRIPTION

       diffmk  compares  two versions of a file and creates a third version that includes "change mark" (.mc) commands for nroff(1) and  troff(1).
       oldfile and newfile are the old and new versions of the file. diffmk generates markedfile, which,  contains  the  text  from  newfile  with
       troff(1) "change mark" requests (.mc) inserted where  newfile differs from  oldfile. When markedfile is formatted, changed or inserted text
       is shown by  | at the right margin of each line. The position of deleted text is shown by a single *.

USAGE

       See largefile(5) for the description of the behavior of diffmk when encountering files greater than or equal to 2 Gbyte ( 2^31 bytes).

EXAMPLES

       Example 1 An example of the diffmk command.

       diffmk can also be used in conjunction with the proper  troff requests to produce program listings with marked changes.	In  the  following
       command line:

	 example% diffmk old.c new.c marked.c ; nroff reqs marked.c | pr

       the file reqs contains the following troff requests:

	 .pl 1
	 .ll 77
	 .nf
	 .eo
	 .nh

       which eliminate page breaks, adjust the line length, set no-fill mode, ignore escape characters, and turn off hyphenation, respectively.

       If the characters  | and * are inappropriate, you might run  markedfile through	sed(1) to globally change them.

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Availability		     |SUNWdoc			   |
       +-----------------------------+-----------------------------+

SEE ALSO

       diff(1), nroff(1), sed(1), troff(1), attributes(5), largefile(5)

BUGS

       Aesthetic  considerations  may  dictate	manual	adjustment of some output. File differences involving only formatting requests may produce
       undesirable output, that is, replacing .sp by .sp 2 will produce a "change mark" on the preceding or following line of output.

SunOS 5.11							    14 Sep 1992 							 diffmk(1)