Actually, I have a comma delimited .csv file with 7 columns. Rows can be any.
Using the below code, I framed the HTML part of the .csv file and am able to send it to the mail.
Now, when I checked the mail, some of the columns for adjacent rows in the output has equal data.
Example:
My output is like -
With this said my sample output, I need to merge all the adjacent rows which has equal values as we do in the excel sheet before sending the data in the mail so that it looks a bit tidy.
With the code which I have pasted with my question, I was able to merge the equal values of adjacent rows in the first column alone. But, its not merging (or combining) the equal values in other rows and columns.
Where am I missing that part and is there any way I can achieve this.
I hope now my problem is clear.
Moderator's Comments:
edit by bakunin: please use CODE-tags for data too. Thank you.
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)
Discussion started by: Snehasish
1 Replies
LEARN ABOUT CENTOS
th_init_cell
thai/thcell.h(3) libthai thai/thcell.h(3)NAME
thai/thcell.h -
Thai string cell custering.
SYNOPSIS
Data Structures
struct thcell_t
Thai char cell representation.
Functions
void th_init_cell (struct thcell_t *cell)
Initialize a Thai cell.
size_t th_next_cell (const thchar_t *s, size_t len, struct thcell_t *cell, int is_decomp_am)
Get first cell from string.
size_t th_prev_cell (const thchar_t *s, size_t pos, struct thcell_t *cell, int is_decomp_am)
Get previous cell from string.
size_t th_make_cells (const thchar_t *s, size_t len, struct thcell_t cells[], size_t *ncells, int is_decomp_am)
Tokenize string into cells.
Detailed Description
Thai string cell custering.
Function Documentation
void th_init_cell (struct thcell_t *cell)
Initialize a Thai cell.
Parameters:
cell : pointer to the cell to initialize
Initializes values in the Thai cell struct.
size_t th_make_cells (const thchar_t *s, size_tlen, struct thcell_tcells[], size_t *ncells, intis_decomp_am)
Tokenize string into cells.
Parameters:
s : the string
len : the length of string
cells : the array of output cells buffer
ncells : the address of integer storing the number of cells provided by the buffer, and to keep the number of resulting cells on return
is_decomp_am : whether SARA AM is to be decomposed into NIKHANIT and SARA AA and to be in separate cells
Returns:
total characters consumed
Tokenizes the string bounded by s and len into cells, and stores at most *ncells resulting cells in the cells buffer. On return, *ncells is
also set to the total cells stored in cells[].
size_t th_next_cell (const thchar_t *s, size_tlen, struct thcell_t *cell, intis_decomp_am)
Get first cell from string.
Parameters:
s : the string
len : the length of string
cell : the output buffer
is_decomp_am : whether SARA AM is to be decomposed into NIKHANIT and SARA AA and to be in separate cells
Returns:
total chars consumed by the cell
Gets first cell from the string bounded by s and len, and, if cell is not null, stores the cell data in it.
size_t th_prev_cell (const thchar_t *s, size_tpos, struct thcell_t *cell, intis_decomp_am)
Get previous cell from string.
Parameters:
s : the string
pos : the position in string to get cell previous to
cell : the output buffer
is_decomp_am : whether SARA AM is to be decomposed into NIKHANIT and SARA AA and to be in separate cells
Returns:
total chars consumed by the cell
Gets last cell from the string bounded by s and pos, and if cell is not null, stores the cell data in it.
Author
Generated automatically by Doxygen for libthai from the source code.
Version 0.1.14 Tue Jun 17 2014 thai/thcell.h(3)