Search Results

Don't modify posts (as you did in post#11) after someone has replied to or referenced them, as it will confuse people reading the thread later on. If you feel you revealed personal or classified...

Version without tac - a bit more intricate, of course, doing everything in memory:
awk -F, '

{HOLD[NR] = $0
}

END {for (nr=NR; nr; nr--) {nf = split(HOLD[nr], HTMP)
...

Well, tac is the "reverse cat" and I thought it were generally available. If your sed snippet provides the same functionality, all should work well...

Different approach, hopefully simpler:
tac file | awk '
BEGIN {
FS=","
# print "MIME-Version: 1.0"
# print "Content-Type: text/html"
# print...

Because one does not know in advance what the rowspan value is, one needs to store at least a bunch of lines in memory.
The following stores all the lines in memory, and prints everything in the END...

The thing is, HTML and CSV are not hundred percent identical. In HTML you can use that rowspan and colspan clauses (to <td>) to expand cells across row/column boundaries. There is no such thing in...

Would
awk -F, '{for (i=1; i<=NF;i++) if ($i == T[i]) $i = ""; else T[i] = $i} 1' OFS=, file
12345,XYZ,123,PPP,01,AAAAAAAAAA,DEFGDEFG
,,234,ABC,02,,
,,567,,05,,HHHHHHH
45167,,809,,09,BBBBBBBBBB,...

OK, understood, but what is considered "equal values"? Is (in the above example) line 1 equal to line 2 because fields 6 and 7 match? Or because fields 1 and 2 match and therefore line 3 is also...

Just write link as text. This is just a security measure against spammers and we (the moderators) will change it to a link if it is a legit reference. You will be allowed to post links yourself once...