This is the simplest answer, if the table data is the same and ONLY in that 7th table data and nowhere else you could use this:
NOTE
I am using "|" as the delimeter and not "/" so I do not have to escape the "/" in "</td>"...
However if you have other table data fields with the same text and you wish to keep these other cels you may wish to use a loop to parse the tokens and count the "<td>" occurances and then do a test to figure out if this cel matches what you are looking for before handing to sed.
SIMPLE EXAMPLE OF LOOP:
Note that this does NOT account for multiple "<td>" tags on one line.
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... (21 Replies)
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... (1 Reply)
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... (7 Replies)
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... (2 Replies)
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!
;... (1 Reply)
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;... (11 Replies)
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... (1 Reply)
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... (17 Replies)
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 ... (5 Replies)
Discussion started by: pedro88
5 Replies
LEARN ABOUT DEBIAN
dbs_dumptabstruct
DBS_DUMPTABSTRUCT(1p) User Contributed Perl Documentation DBS_DUMPTABSTRUCT(1p)NAME
dbs_dumptabstruct - Creates file set with SQL table schemas
DESCRIPTION
dbs_dumptabstruct is an utility to create a file set with SQL table schemas. For each table in the database dbs_dumptabstruct calls the
appropriate dumper utility with the output directed to a file named table.sql in the current directory. dbs_dumptabstruct asks for a pass-
word if necessary.
COMMAND LINE PARAMETERS
Required command line parameters are the DBI driver ("Pg" for Postgres or "mysql" for MySQL) and the database name. The third parameter is
optionally and specifies the database user and/or the host where the database resides ("racke", "racke@linuxia.de" or "@linuxia.de").
COMMAND LINE OPTIONS -d=OPTIONS, -o=OPTIONS, --dump-options=OPTIONS
Pass options to the dumper utility, e.g. "--compatible=mysql40".
-p, --pipe
Prints the table dumps to standard output.
-t TABLE[,TABLE,...], --tables=TABLE[,TABLE,...]
Comma-separated list of tables to dump.
--exclude-matching-tables=REGEXP
Excludes any table matching the regular expression REGEXP from dumping.
BUGS
Only mysql and Pg drivers are supported.
AUTHOR
Stefan Hornburg (Racke), racke@linuxia.de
VERSION
0.17
SEE ALSO perl(1), DBIx::Easy(3)perl v5.8.8 2007-02-01 DBS_DUMPTABSTRUCT(1p)