Considering the sample output below:
In the first column we have 12345 value present in first 3 rows. So for the first 3 rows, first column should be a merged value showing single merged value 12345 instead of 3. In other words equivalent to rowspan in HTML or Merge in Excel sheet.
considering last 2 rows, instead of it displaying 45167 value twice it should only display it once with 4th and 5th rows first column as a merged cell.
If you consider second column, all the values in that column for all rows is XYZ. So, instead of showing the same value XYZ 5 times, it should show XYZ as a single value with all 5 cells as a single merged cell.
Similarly for others.
Say this is the initial HTML format I got in mail
The same should be converted to below.
I hope this gives a clear picture.
Last edited by Mounika; 01-18-2018 at 01:56 AM..
Reason: Provided modified output which is needed.
I'd like to use sed or awk to do this but I'm weak on both along with RE. Looking for a way with sed or awk to count for the 7th table data within a table row and if the condition is met to delete "<td>and everything in between </td>". Since the table header start on a specific line each time, that... (15 Replies)
Hi guz I want to merge multiple rows into a multiple columns based on the first column.
The file has symbol //
I want to break the symbool // and I nedd exactlynew column at that point
the output will be like this
please guyz help in this isssue!!!!!
merging rows into columns ... (4 Replies)
I've got the following form element in a template driven web page...
<INPUT type="text" class="normal" id="LastName" name="LastName" value="{LastName}">
The stylesheet description is simply...
input.normal { width: 250; }
I want to change the background colour of the input box after the user... (0 Replies)
Hi UNIX Gods!
Is it possible to merge two cells in .csv file using unix commands?
Imagine that this is my present csv file opened via excel:
Gate Reports| |
fatal alerts | 200 |
is is possible to make it look like this using unix?
Gate Reports |
fatal... (1 Reply)
I have bash, awk, and sed available on my portable device. I need to extract 10 fields from each table row from a web page that looks like this:
</tr>
<tr>
<td>28 Apr</td>
<td><a... (6 Replies)
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)
I have to send a data in mail table format.only one cell need to get dynamically from query.
my code is like
(echo '<table boarder="1">
echo '<tr><td>stock</td><td>/path</td><td>.........</td></tr>'
echo '</table>
)sendmail..
in ......... I am trying to get query result.By putting query... (2 Replies)
I have below 2 requirements for parameterize the generate the extract file from Oracle table using Shell Script. Could you please help me by
modifying the script and show me how to execute it.
First Requirement:
I have a requirement where I need to parameterize to generate one... (0 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)
Hi all
I have written some code to write my output in html.
As i have multiple servers, need to generate single html file. but my code is generating html file for each server.
I have merged the files using below code.
cat /home/*_FinalData.html > /home/MergedFinalData.html
But how to... (1 Reply)